Hi All,
I need some help making a formula, hopefully it should be relativley straight forward..
Basically, i need a formula, not unlike an IF statment, to tell me if a given date falls inside or outside a date range.
For example.. Lets say the date I have is 07/07/2011
And I want to see if this date falls between the 01/04/2011 and 21/09/2011
Logic as follows... IF "mydate" is Bewteen "date1" and "date2" then return the value "Yes"
Hope that helps explain?
Thank you very much for your help in advance
Last edited by techteam; 07-29-2011 at 09:42 AM.
Would something like this work?
Assuming your start date is in A1, your end date is in B1, and the date you're querying about is in C1, put this in D1
=AND(C1-A1>0,C1-B1<0)
Many thanks for your help! - worked perfectly :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks