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(TODA Y()+4)=1,TODAY()+5))

--
---
HTH

Bob


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



"des-sa" wrote in message
...
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(NOW()+4,2)=6,NOW()+6,IF(WEEKDAY(NOW()+ 4,2)=7,NOW()+5,NOW()))

"des-sa" wrote:

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?

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

"Joel" wrote:

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

"des-sa" wrote:

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?

On Tue, 13 May 2008 03:18:01 -0700, des-sa
wrote:

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