View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thufir Howat Thufir Howat is offline
external usenet poster
 
Posts: 2
Default Subtract 6 months

Well, here is the quick and dirty.

=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))

Hopefully someone has a more elegant solution.

Lynn wrote:
I would like to create a formula that will subtract 6 months from today's
date. What function can I use for this?