Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am enter a date in a cell and in another cell i would like to input a
formula that will add or substract 6 months or more from the orginal date
cell?
 
One way:

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

Note that months are squirrely concepts...
 

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

using dates and time in formulas 1
Dates again 9
Excel Import Comments 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Convert Number of Month to Number of days 4
Please help with a date formula. 3
Leave "formula cell J7" empty until H7 has a date. 2
Formula help 1

Back
Top