is it possible to reconize the day of week

  • Thread starter Thread starter des-sa
  • Start date Start date
D

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?
 
=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)
 
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?
Click to expand...

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
 
Back
Top