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'm a total Numbers novice, but I'm trying to figure out how to track total travel days in a rolling 180 days. So I need to be able to enter dates and get a total number of days, but I then need to tally multiple rows of days traveled to calculate how many total days traveled in 180 from the current day.
If the dates are in column A,
=COUNTIFS(A,"<="&TODAY(),A,">="&TODAY()−179)
I think the correct number to use in the formula is 179, not 180. For example, lets say it was a rolling 2 day period. That would be today and the day before, which is TODAY and TODAY-1 not TODAY-2.
If the dates are in column A,
=COUNTIFS(A,"<="&TODAY(),A,">="&TODAY()−179)
I think the correct number to use in the formula is 179, not 180. For example, lets say it was a rolling 2 day period. That would be today and the day before, which is TODAY and TODAY-1 not TODAY-2.
Hi Trynly,
We are not looking over your shoulder. Please post a screen shot of the relevant part of your table, so that we can see what you see. Make any sensitive data anonymous before you take the screen shot.
Regards,
Ian.
So I tried that but it won't tally multiple trips. I need to be able to tally the total number of days from multiple trips and find out how many days in a rolling 180 there are. Any thoughts?
Counting days in rolling calendar dates in Numbers
