Previous Topic Next Topic

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

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

Thanks Tom9o
0