Formula for Between to Dates

Solved/Closed
Tom9o
Posts
11
Registration date
Monday February 18, 2013
Status
Member
Last seen
September 15, 2013
- Feb 19, 2013 at 10:08 PM
 Tom9o - Feb 23, 2013 at 06:21 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 20, 2013 at 01:10 AM
try
=IF(AND(A1<>"", A1>=$H$1, A1<=$G$1),A1,"")
0
Hi rizvisa thanks for this have been away so this is whay the late responce, this works ok,

Thanks Tom9o
0