Jun 11 2020 07:20 AM
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)
Jun 11 2020 07:31 AM - edited Jun 11 2020 07:34 AM
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