Date formula

[hmsawyer]

I need a formula that will determine if dates ( formatted xx/xx/xx)in column
B & C are = or greater than 1 year apart and if so to return value "Yes", if
not return value "No".

Thank you!

 

[Mike]

=IF(C1-B1>=365,"Yes","No"

 

[Tyro]

If B1 contains the starting date and C1 contains the ending date then :

=IF(DATEDIF(B1,C1,"y")>=1,"Yes","No")

Dates are simply numbers. Excel's date range is Jan. 1, 1900 is day 1 and
Dec. 31, 9999 is day 2,958,465.
If you format those numbers as dates you'll see dates, but they are just
numbers. Formatting does not change cell values.
The DATEDIF function takes leap years into account.
The function is documented in many books on Excel and at
http://www.cpearson.com/excel/datedif.aspx

Tyro

 

[Rick Rothstein \(MVP - VB\)]

What about Leap Years?

Rick

=IF(C1-B1>=365,"Yes","No"