Dates until deadline subtracting weekends

Copper Contributor

I am trying to set up a spreadsheet that will either tell me how many days until the data reaches 180 days (taking out weekends) or how old the date is (taking out weekends) but I cannot get this to work.  Any suggestions?  In other words: 180 days from 06/11/2020 equals:  (not counting weekend days) 

1 Reply

@Jenna_Martin 

 

If I'm correctly understanding you, you can find a date XXX work days from now by using the formula

=WORKDAY(TODAY(),XXX)

substituting for the XXX the number of your choosing.

 

Ideally, unless you're always going to be using 180, you'd make that a reference to another cell, where you could change it to any kind of WORKDAY gap.

 

P.S. By the way, 180 days from 06/11/2020 equals: (not counting weekend days) = 2/18/21