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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

names dates & amounts stated multiple times in document 0
How do I use the IF function with info that contains a date? 1
Divide month into two payroll periods 5
Excel Help with dates 2
Exclude weekends when counting days only on day 29 or 30 3
how do i calculate the number of days between two dates? 3
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Finding Number of Particular Dayns Problem in a Period 3

Back
Top