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 think people should be allowed to list their rented apartments on Airbnb?

Discuss in The Lounge

Poll History