Check if a date comes before/after a range of dates

Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by ChooseParkay

I believe this can be solved with a =vlookup

Is this what you mean?
Not done with a VLOOKUP but rather an array IF formula.

Attached Files

Jay07 Example.zip (6.6 KB, 32 views)

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
Check dates against a date range.	hombreazul	Excel Discussion (Misc queries)	0	January 30th 12 12:57 AM
Check if date is between two dates, then sum only those rows	streetcar	Excel Worksheet Functions	2	February 16th 10 12:19 PM
Dates: How to check if date value is 10 months and or 1 year old?	Rick S.	Excel Programming	8	October 2nd 07 03:30 PM
How to count dates within a certain range in a column with mutiple date range entries	Krisjhn	Excel Worksheet Functions	2	September 1st 05 01:59 PM
Check column of dates against todays date	Andrew82	Excel Worksheet Functions	1	April 15th 05 11:17 AM

All times are GMT +1. The time now is 05:41 AM.

About Us