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

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.

Ask Your Question

Weekly Poll

Do you often forget where you parked your car?

Discuss in The Lounge

Poll History