How to subtract/add periods in monthly base?

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

Guest

Does anyone know how to subtract/add periods in monthly base? for example,

Dec 2006 [in cell A1] - 3 [in cell B1] months = Sep 2006 [in cell C1]
Dec 2006 [in cell A1] + 2 [in cell B2] months = Feb 2007 [in cell C1]

and ignore to count the numebr of days, because the number of days for each
month is different.
Does anyone have any suggestion?
Thank you
Eric
 
Try this:

I'm assuming that cell A1 contains a true Excel date but is formatted as mmm
yyyy.

=DATE(YEAR(A1),MONTH(A1)-3,1)
=DATE(YEAR(A1),MONTH(A1)+2,1)

Format as mmm yyyy

Biff
 
Thank you very much
Eric

T. Valko said:
Try this:

I'm assuming that cell A1 contains a true Excel date but is formatted as mmm
yyyy.

=DATE(YEAR(A1),MONTH(A1)-3,1)
=DATE(YEAR(A1),MONTH(A1)+2,1)

Format as mmm yyyy

Biff

Eric said:
Does anyone know how to subtract/add periods in monthly base? for example,

Dec 2006 [in cell A1] - 3 [in cell B1] months = Sep 2006 [in cell C1]
Dec 2006 [in cell A1] + 2 [in cell B2] months = Feb 2007 [in cell C1]

and ignore to count the numebr of days, because the number of days for
each
month is different.
Does anyone have any suggestion?
Thank you
Eric
Click to expand...
Click to expand...
 
You're welcome!

Biff

Eric said:
Thank you very much
Eric

T. Valko said:
Try this:

I'm assuming that cell A1 contains a true Excel date but is formatted as
mmm
yyyy.

=DATE(YEAR(A1),MONTH(A1)-3,1)
=DATE(YEAR(A1),MONTH(A1)+2,1)

Format as mmm yyyy

Biff

Eric said:
Does anyone know how to subtract/add periods in monthly base? for
example,

Dec 2006 [in cell A1] - 3 [in cell B1] months = Sep 2006 [in cell C1]
Dec 2006 [in cell A1] + 2 [in cell B2] months = Feb 2007 [in cell C1]

and ignore to count the numebr of days, because the number of days for
each
month is different.
Does anyone have any suggestion?
Thank you
Eric
Click to expand...
Click to expand...
Click to expand...
 

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

How to count the number of months between 2 periods? 3
How to set the function - countif? 4
How to determine the number of month between 2 periods? 5
Dates problem 1
How to change the year digit? 4
Find the position of a date 6
How to measure time for processing periods? 6
Add one Month in the next cell for several months/years 3

Back
Top