Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 12

account for weekends in date formula

I have the following formula set in one of my columns

=IF(OR(ISBLANK($A5),ISBLANK(Q5)),"",N5+1)

I need this to account for weekend days however and if Q5 falls on a Friday
to add 3 (so that the formula returns a date for monday, and if Q5 falls on a
Saturday to add 2 (again so that the formula returns a date for Monday.) The
remainder of the formula needs to stay intact however, as there are other
functions that depend on it.

Any help would be greatly appreciated.

Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date formulas	DRondeau	Excel Discussion (Misc queries)	7	September 6th 06 09:53 PM
date formula	hitesh	Excel Discussion (Misc queries)	0	August 29th 06 05:01 PM
Mileage Claim Formula	johndavies	New Users to Excel	4	August 14th 06 09:24 AM
Trending Formula Results by Date	sony654	Excel Worksheet Functions	0	January 2nd 06 02:33 AM
date that updates itself daily, plus another formula please??	Ted	Excel Worksheet Functions	2	November 26th 05 03:36 PM

All times are GMT +1. The time now is 08:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us