Posted to microsoft.public.excel.worksheet.functions

Romanli

external usenet poster

Posts: 5

Using IF and date ranges

I am trying to find information that meets the following criteria:

If n2is between 07/01/2008 and 07/23/2008 and 02 is between 08/01/2008 and
08/31/2008 then the answer is yes

I really want to highlight the row with this information, but a simple yes
or no in a new column would be fine.

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
If and Date Ranges	Romanli	Excel Worksheet Functions	1	July 25th 08 04:42 AM
date ranges	Carolina Girl	Excel Worksheet Functions	3	May 9th 08 10:07 PM
compare date to various date ranges and sum value	al	Excel Worksheet Functions	2	January 10th 07 10:17 AM
If then Date Ranges	Mark B	Excel Worksheet Functions	0	November 30th 05 05:49 PM
sum of date ranges	Tanya	Excel Worksheet Functions	1	January 4th 05 04:11 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us