chungtinhlak
02-25-2009, 10:27 AM
is there a formula to subtract dates but exclude weekends.
Example, cell Q1, i have =Today()
I want Cell P1 to be QA1 - 1 and the formula remains constain all the way to A1. But the problem is I have weekends in there. Is there a way to skip the weekend?
attached is example.
Example, cell Q1, i have =Today()
I want Cell P1 to be QA1 - 1 and the formula remains constain all the way to A1. But the problem is I have weekends in there. Is there a way to skip the weekend?
attached is example.