Previous Topic Next Topic

Formula for Between to Dates

Solved/Closed
Tom9o Posts 10 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 20, 2013 at 01:10 AM
try
=IF(AND(A1<>"", A1>=$H$1, A1<=$G$1),A1,"")
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

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
using web browser page loads but screen blank
inchoate -
leo -

16 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response