Date between date range

Posted to microsoft.public.excel.misc

AJ[_4_]

external usenet poster

Posts: 14

Date between date range

I am trying to compare a date for an invoice to see if it falls between a
date range and then I want it to return a value.

For example
Column A Column B Column C
10/4/2008 11/2/2008 Oct 2008
11/3/2008 12/1/2008 Nov 2008
12/2/2008 01/03/2009 Dec 2008

If I have a date of 10/28/2008 in another field, I would like for it to
search to see what date range (between column A and B) it would match and
then return the value from column C. There will be multiple dates that I
will need to check.

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
Need a formula to determine if date falls within a date range then	Corca	Excel Worksheet Functions	2	September 19th 08 09:36 AM
Create a formula in a date range to locate a specific date - ecel	util	Excel Discussion (Misc queries)	0	February 19th 07 03:03 PM
return a date from range, date is between dates in two other cells	NN	Excel Discussion (Misc queries)	1	September 28th 06 10:05 PM
Formula for determining if two date columns fall within specific date range	Igottabeme	Excel Worksheet Functions	2	April 21st 06 02:50 AM
Formula for determining if two date columns fall within specific date range	Igottabeme	Excel Discussion (Misc queries)	1	April 20th 06 10:03 PM

All times are GMT +1. The time now is 01:28 PM.

Menu

About Us