How to subtract/add periods in monthly base?

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
 
T

T. Valko

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
 
G

Guest

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...
 
T

T. Valko

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 measure time for processing periods? 6
How to determine the number of workday between two periods? 1
How to determine the number of month between 2 periods? 5
How to determine the number of months between 2 periods? 2
How to set the function - countif? 4
formula for adding x periods/mo add 11% to each 2
How to change the year digit? 4

Top