A
arunsharm82
Hi,
Is there any way of automatically calculating dates in Excel?
For example I am creating a spreadsheet that is being used for quoting
new programs.
I want to have a table that has some timing information, like start of
production (year), Month of production (i.e. 5) and then the program
Life (6 years).
I want Excel to fill out all of the years in a separate table with the
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 want
Excel to display:
2003 (7 Months) - [this is the remainder of production months left in
the year.]
2004 (12 Months)
2005 (12 Months)
2006 (4 Months) - [amount of months of production up to May]
Thanks again in advance.
Is there any way of automatically calculating dates in Excel?
For example I am creating a spreadsheet that is being used for quoting
new programs.
I want to have a table that has some timing information, like start of
production (year), Month of production (i.e. 5) and then the program
Life (6 years).
I want Excel to fill out all of the years in a separate table with the
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 want
Excel to display:
2003 (7 Months) - [this is the remainder of production months left in
the year.]
2004 (12 Months)
2005 (12 Months)
2006 (4 Months) - [amount of months of production up to May]
Thanks again in advance.