Formula for Between to Dates

[Solved/Closed]
Report
Posts
11
Registration date
Monday February 18, 2013
Status
Member
Last seen
September 15, 2013
-
 Tom9o -
Hello,

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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
try
=IF(AND(A1<>"", A1>=$H$1, A1<=$G$1),A1,"")
Hi rizvisa thanks for this have been away so this is whay the late responce, this works ok,

Thanks Tom9o