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.
=IF(WEEKDAY(Q1)=2,Q1-3,Q1-1)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
wow you make everything looks easy xld. thanks
Just keep in mind that this will not work if the date in Q1 is a Sunday (WEEKDAY(Q1)=1). Since it looks like this can't occur in your case, this is not an issue for you.Originally Posted by xld
Posting Permissions
Reply With Quote
