Posted to microsoft.public.excel.worksheet.functions

Rachael F

external usenet poster

Posts: 16

Greater than 5 days formula

I would like help with a formula for the following:

If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'

Many thanks.

Rachael

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
Re Change 5 week days to 7 days in this formula	pano	Excel Worksheet Functions	7	February 1st 07 04:20 PM
Greater than formula	Angela	Excel Worksheet Functions	2	January 22nd 07 01:47 PM
Greater than formula	Tracey	Excel Worksheet Functions	2	January 5th 06 09:02 PM
Greater than formula!	nekteo	Excel Worksheet Functions	2	December 29th 05 05:09 PM
formula for Greater of C or D X E	[email protected]	Excel Discussion (Misc queries)	2	October 11th 05 07:26 PM

All times are GMT +1. The time now is 05:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us