How to subtract/add periods in monthly base?

E

Eric

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
 
E

Eric

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 month between 2 periods? 5
How to determine the number of workday between two periods? 1
Looking to added up based on a character from cell range 1
How to set the function - countif? 6
How to dynamically add up varying # of cells base on a value 6
How to determine the number of months between 2 periods? 2

Top