Dashboard with formula for dates less than 60, less than 30 and overdue

%3CLINGO-SUB%20id%3D%22lingo-sub-2357594%22%20slang%3D%22en-US%22%3EDashboard%20with%20formula%20for%20dates%20less%20than%2060%2C%20less%20than%2030%20and%20overdue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2357594%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Power%20Users%2C%3C%2FP%3E%3CP%3EI've%20created%20a%20dashboard%20for%20my%20team%20that%20shows%20our%20progress%20comparing%20our%20actuals%20vs%20forecasted%20on%20tasks.%20I'm%20having%20trouble%20with%20figuring%20out%20how%20to%20show%20what%20is%20forecasted%20for%20the%20next%2060%20days%2C%2030%20days%2014%20days.%20I%20just%20want%20to%20show%20a%20count%20of%20how%20may%20dates%20are%20coming%20up%20from%20a%20column%20of%20dates.%20I%20tried%20using%20a%20Countif%20and%20combined%20it%20with%20%3DTODAY()%2B30%20but%20it%20wouldn't%20work%20for%20me.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2357594%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2357611%22%20slang%3D%22en-US%22%3ERe%3A%20Dashboard%20with%20formula%20for%20dates%20less%20than%2060%2C%20less%20than%2030%20and%20overdue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2357611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1054737%22%20target%3D%22_blank%22%3E%40aimster1525%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESomething%20like%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIF(D2%3AD100%2C%20%22%26lt%3B%3D%22%26amp%3BTODAY()%2B60)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewhere%20D2%3AD100%20is%20a%20range%20with%20dates.%20If%20you%20want%20to%20count%20dates%20between%20today%20and%20today%2B60%20days%2C%20use%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIFS(D2%3AD100%2C%22%26gt%3B%3D%22%26amp%3BTODAY()%2CD2%3AD100%2C%22%26lt%3B%3D%22%26amp%3BTODAY()%2B60)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

1 Reply

@aimster1525

 

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)