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!
 
tnazirov

tnazirov

Joined
Jan 1, 2010
Messages
5
Reaction score
0
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
Divide month into two payroll periods 5
How do I use the IF function with info that contains a date? 1
Excel Help with dates 2
If Function and Dates 13
how do i calculate the number of days between two dates? 3
IF Function with Dates 9
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3

Top