Solved: working with Dates

[chungtinhlak]

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.

[Bob Phillips]

=IF(WEEKDAY(Q1)=2,Q1-3,Q1-1)

[chungtinhlak]

wow you make everything looks easy xld. thanks

[Sagy]

=IF(WEEKDAY(Q1)=2,Q1-3,Q1-1)
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.