Posted to microsoft.public.excel.worksheet.functions

Dan

Posts: n/a

Conditional If statement

Have the following equation:

{=IF(($E40:$E50<TODAY())*($E40:$E50TODAY()-21),$E40:$E50)}

which returns either the date in the cell or "FALSE". I want to modify the
equation to only return the dates in the range of cells. E40:E50 may contain
from 0 to 11 responses that match the criteria.

Your help is appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Conditional formating on if statement	SCOOBYDOO	Excel Worksheet Functions	2	November 30th 05 06:58 PM
Conditional Statement in Charts	smck	Excel Worksheet Functions	2	November 12th 05 03:38 AM
conditional statement	mjstizzle	New Users to Excel	1	June 29th 05 05:18 PM
How can I use HYPERLINK in a conditional statement between sheets	Mikey	Excel Worksheet Functions	1	May 3rd 05 08:07 PM
Conditional Statement with ANDs	Stephen	Excel Discussion (Misc queries)	2	April 11th 05 04:41 PM

All times are GMT +1. The time now is 10:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us