May 15 2021 01:08 PM
Hi Power Users,
I've created a dashboard for my team that shows our progress comparing our actuals vs forecasted on tasks. I'm having trouble with figuring out how to show what is forecasted for the next 60 days, 30 days 14 days. I just want to show a count of how may dates are coming up from a column of dates. I tried using a Countif and combined it with =TODAY()+30 but it wouldn't work for me.
Thank you in advance
May 15 2021 01:20 PM
Something like
=COUNTIF(D2:D100, "<="&TODAY()+60)
where D2:D100 is a range with dates. If you want to count dates between today and today+60 days, use
=COUNTIFS(D2:D100,">="&TODAY(),D2:D100,"<="&TODAY()+60)