Automatic Date Calculations

[arunsharm82]

Hi,

Is there any way of automatically calculating dates in Excel?

For example I am creating a spreadsheet that is being used for quotin
new programs.

I want to have a table that has some timing information, like start o
production (year), Month of production (i.e. 5) and then the progra
Life (6 years).

I want Excel to fill out all of the years in a separate table with th
corresponding amount of months of production in that year.

I.e.

If the start date is May 2003 and the program life is 3 years, I wan
Excel to display:
2003 (7 Months) - [this is the remainder of production months left i
the year.]
2004 (12 Months)
2005 (12 Months)
2006 (4 Months) - [amount of months of production up to May]

Thanks again in advanc

 

[Guest]

You should be able to set this up using a combination of DATEDIF and DATE functions. For info on the DATEDIF function got to Chip Peasron's web site at

http://www.cpearson.com/excel/datedif.ht

I have put together a spread sheet which might give you some ideas. Post your email address or send an e-mail directly to me and I will send you the file

One thing I notice in your example is that your 3 year project only contains 35 months

Good Luck
Mark Graesse
(e-mail address removed)

----- arunsharm82 > wrote: ----

Hi

Is there any way of automatically calculating dates in Excel

For example I am creating a spreadsheet that is being used for quotin
new programs

I want to have a table that has some timing information, like start o
production (year), Month of production (i.e. 5) and then the progra
Life (6 years)

I want Excel to fill out all of the years in a separate table with th
corresponding amount of months of production in that year

I.e

If the start date is May 2003 and the program life is 3 years, I wan
Excel to display
2003 (7 Months) - [this is the remainder of production months left i
the year.
2004 (12 Months
2005 (12 Months
2006 (4 Months) - [amount of months of production up to May

Thanks again in advanc