You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I want to create a formula with (sumif) & (today) fuctions. The formula would go something like if the dates on column A are => than todays date then add column B. But I can’t figured out how to incorporate => with (today) function.
[Re-Titled By Moderator]
iMac 27″, macOS 14.3
Formula for B12= SUMIF(A,"<="&(TODAY()−WEEKDAY(TODAY(),2)+7),B)
Here some details:
WEEKDAY(TODAY(),2) will return 5, if Monday is 1 then Friday (today) is 5
TODAY()−WEEKDAY(TODAY(),2) will return last Sunday 25. Aug.
TODAY()−WEEKDAY(TODAY(),2)+7 will return next Sunday 1. Sep.
Formula for B12= SUMIF(A,"<="&(TODAY()−WEEKDAY(TODAY(),2)+7),B)
Here some details:
WEEKDAY(TODAY(),2) will return 5, if Monday is 1 then Friday (today) is 5
TODAY()−WEEKDAY(TODAY(),2) will return last Sunday 25. Aug.
TODAY()−WEEKDAY(TODAY(),2)+7 will return next Sunday 1. Sep.
Hello Hendher,
please try this.
Formula for B12= SUMIF(A,">="&TODAY(),B)
Row 12 is a Footer Row !!
You have to connect the >= with Today, that is done with ">=" and &.
Regards Ralf
Today is Friday 30. Aug. 2024, you want all values that are on / before Monday 26. Aug. or all values on / before Sunday 25. Aug. ?
Awesome that worked perfect. Follow up question, is there any way that i could do instead of being today. It could be this week? Meaning if the dates on column A <= to this current week (Mon-Sun) then add column B?
All values on or before Sunday 1. Sep 2024.
Next week (meaning on monday) I want all values on or before Sunday 8. Sep 2024
WOW that's awesome you just made my life so much easier, THANKS 1,000 times. You really know your Numbers functions.
create a formula with (sumif) & (today) fuctions
