Articles

Solved Find if a Date is between to Dates

February 19, 2013 at 19:17:59
Specs: Windows 7

Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column “A” I have a list of dates and in cell “G1” I have 13/2/13 and in Cell “H1” I have 20/2/13. I am looking for an formula that will tell me if the dates in column ”A” are between these two dates, if I run the formula in column “C” I am wanting the date if it is between the two dates to show up in the opposite cell in column C if it is not then it shows a blank in the opposite cell in column C, I guess an “IF” formula is required but I cannot work out how to show the between part for the two dates

See More: Find if a Date is between to Dates

Report •


#1
February 20, 2013 at 05:50:44
✔ Best Answer

You should be able to use the Greater Than and Less Than operators with an AND function:

=IF(AND(A1>$G$1,A1<$H$1),A1,"")

Both of the arguments for the AND function must be TRUE for the IF function to be TRUE.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question