G Guest... Joined May 26, 2018 Messages 2 Reaction score 0 May 26, 2018 #1 I am trying to count dates that are approaching a due date within the next 30 days, I have tried multiply ways but am just forgetting something. Any help would be greatly appreciated.
I am trying to count dates that are approaching a due date within the next 30 days, I have tried multiply ways but am just forgetting something. Any help would be greatly appreciated.
Becky Webmistress Joined Mar 25, 2003 Messages 7,424 Reaction score 1,511 May 28, 2018 #2 So you have a list of dates and you want to count how many fall within the next 30 days? You can use this formula for that: =COUNTIF(A1:A10,"<"&(TODAY()+30)) Just replace A1:A10 with your range and you're good to go
So you have a list of dates and you want to count how many fall within the next 30 days? You can use this formula for that: =COUNTIF(A1:A10,"<"&(TODAY()+30)) Just replace A1:A10 with your range and you're good to go
G Guest... Joined May 26, 2018 Messages 2 Reaction score 0 May 29, 2018 #3 Thank you Becky, that is one of the several ways I tried and it doesn't seam to work. It is counting everything in the column.
Thank you Becky, that is one of the several ways I tried and it doesn't seam to work. It is counting everything in the column.
Becky Webmistress Joined Mar 25, 2003 Messages 7,424 Reaction score 1,511 May 30, 2018 #4 Could you take a screenshot of the data?
