Thread: Date formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Date formula
=IF(C1-B1=365,"Yes","No"

"hmsawyer" wrote:

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!
Reply With QuoteReply With Quote