Due Date within 30 Days

Occasional Visitor

I am creating a dashboard and want to add an element that tells users how many goals will be due within 30 days of the original goal date.  I want to ensure the count is only for workdays.  What is the formula that I would use?

 

Sample Goals Dates:

2/15/2022
3/25/2022
4/1/2022
5/16/2022
6/25/2022
2 Replies

@Soonergirl97 

Here's another feature that might help.
NETWORKDAYS function

eturns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

Tip:  To calculate whole workdays between two dates by using parameters to indicate which and how many days are weekend days, use the NETWORKDAYS.INTL function.


example =NETWORKDAYS("2/15/2022","3/25/2022")

 

NikolinoDE