How do I Subtract 6 months off a date in excel

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

Hi

Just wanting to subtract 6 months off any date, and present in the format of
a date.

Cheers
 
One way:

A1: <date>
A2: =DATE(YEAR(A1),MONTH(A1)-6,DAY(A1))

Note that A1= 12/31/2008 will return 07/01/2008 in A2 since June has onl
30 days (US formatting).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month 7
Date Calculations 3
Trailing 30 days sum calculation with excel 1
Subtracting months from each other 1
Working With Dates in Excel 2
Subtracting dates from two columns 5
How do I subtract 8 business hours from a date/time value? 5
Excel Date Display? 8

Back
Top