Date searching TRUE/FALSE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I use excel 97. I have the following:
A B
1 1/1/99
2 1/2/99
3 1/3/99
I have the above format up to 8/26/04. I want to enter a formula in cell B1
and "fill down" to 8/26/04 cell. Example: I want the word "TRUE" to come up
for only the 3rd day in January of the last 6 years:
1/3/99 TRUE
1/3/00 TRUE
1/3/01 TRUE
1/3/02 TRUE
1/3/03 TRUE
1/3/04 TRUE
Note: all the dates in between these desired dates will have FALSE after
them. What do I enter in cell B1 to fill down for this "TRUE" result?
Thanks for anyone who can help!
Frank
 
Hi

one method
=IF(AND(MONTH(A1)=1,DAY(A1)=3,YEAR(A1)>YEAR(NOW())-6),TRUE,FALSE)

Cheers
JulieD
 
Thank you JE McGimps & JulieD & Arvi Laane. I appreciate everyones response!
You all are great :-)
Frank
 
Back
Top