Thread: Using Conditional Formatting for Dates
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
  
Posts: 390
Default Using Conditional Formatting for Dates
In , Earl Kiosterud
spake thusly:

DATE(YEAR(TODAY())-2,MONTH(TODAY()), DAY(TODAY())) returns a date
two years ago.

What's wrong with

=TODAY()-365*2

unless you're really worried about leap years.

-dman-
Reply With QuoteReply With Quote