View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nigel Nigel is offline
external usenet poster
 
Posts: 141
Default Subtract one year from todays date

Seems like a fairly simple question but I can't find an answer anywhere,

the date in cell A1 is todays date, and I need to subtract 1 year from that
date, not 365 days because I need to take into account leap years

thanks