Thread: Changing cell if within 365 days?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KrisP KrisP is offline
external usenet poster
  
Posts: 8
Default Changing cell if within 365 days?
Hi,
I need a way of changing the text in a cell if its over 365 days from a date
in a cell A1?

Example - If A1 is 01/06/2008 then cell B2 = yes. If A1 was 01/01/2000 then
B2 = no.

Thanks in advance!

Reply With QuoteReply With Quote