IF function with dates

C

cmc2275

Joined
Sep 17, 2010
Messages
2
Reaction score
0
I have 3 cells:

Start Date
End Date
Date of 16th birthday

I want to create a formula: if 16th birthday falls between start and end (inclusive) then 'yes' and if 16th birthday doesn't fall between those dates (inclusive), then 'no'.

Thanks!
 
Assume that

Start Date located in cell A1

End Date located in cell A2

Date of 16th birthday located in cell A3


then use formula:

=IF(AND(A3>=A1,A3<=A2),"Yes","No")
 
Back
Top