is it possible to reconize the day of week
 

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?

is it possible to reconize the day of week
 

=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?

is it possible to reconize the day of week
 

=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?

is it possible to reconize the day of week
 

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?

is it possible to reconize the day of week
 

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