is it possible to reconize the day of week

[des-sa]

please help,
in my quote i want to state a "due by" date (generated by =now()+4, but if
that date falls on a saturday or sunday it should move the due date on to the
first monday thereafeter. is it possib and how?

 

[Bob Phillips]

=IF(WEEKDAY(TODAY()+4)=7,TODAY()+6,IF(WEEKDAY(TODAY()+4)=1,TODAY()+5))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Joel]

=IF(WEEKDAY(NOW()+4,2)=6,NOW()+6,IF(WEEKDAY(NOW()+4,2)=7,NOW()+5,NOW()))

 

[des-sa]

Joel,
Thanks a million, done, it works!!

=IF(WEEKDAY(NOW()+4,2)=6,NOW()+6,IF(WEEKDAY(NOW()+4,2)=7,NOW()+5,NOW()))

 

[Ron Rosenfeld]

please help,
in my quote i want to state a "due by" date (generated by =now()+4, but if
that date falls on a saturday or sunday it should move the due date on to the
first monday thereafeter. is it possib and how?

If you have the analysis toolpak installed (look under Add-Ins), or if you have
Excel 2007, you can use the formula:

=WORKDAY(TODAY()+3,1)

Note that there is an optional [holidays] argument where you can also exclude
holiday days in calculating your "due by" date.
--ron