Posted to microsoft.public.excel.worksheet.functions

Funkyfido

Posts: n/a

Formula Required

I have the following three columns, No Weeks= 6, Start Date = 31/3/6 End
Date =12/5/6 . I need a formula to calculate a revised date such that if
the End Date is between 3/4/6 and 16/4/6 then I need 14 days added to it.
All other dates to remain unaffected.

Does anyone know a formula to do this.

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
2 Nesting questions	Starchaser	Excel Worksheet Functions	7	January 20th 06 06:53 PM
A Formula required - please!	Anthony	Excel Discussion (Misc queries)	2	July 21st 05 10:11 AM
Formula assistance required!!!	Don	Excel Discussion (Misc queries)	4	February 22nd 05 08:34 PM
addition to my date formula...required	Juco	Excel Worksheet Functions	5	January 30th 05 11:48 AM
Rate of return required formula	Alorasdad	Excel Worksheet Functions	1	November 18th 04 03:14 AM

All times are GMT +1. The time now is 10:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us