Adrian Try wrote:
Hi Lisa
I would like one cell to return an addition or subtraction of months
or years from the date in another call. (whatever the need is)
Have a look at the months and years functions.
This is from the online help:
MONTHS
Calculates the difference in months between two dates.
Syntax
MONTHS(Start date, End date, Type)
Start date: First date
End date: Second date
Type: Calculates the type of difference. Possible values include 0
(interval) and 1 (in calendar months).
YEARS
Calculates the difference in years between two dates.
Syntax
YEARS(Start date, End date, Type)
Start date: First date
End date: Second date
Type: Calculates the type of difference. Possible values are 0
(interval) and 1 (in calendar years).
Hope this helps.
Adrian
www.tryanotherangle.org
Thanks Adrian...that is not quite what I wanted to do.
I have the difference and one date. I do not have two dates to
calculate the difference of. I would like to calculate the 2nd date.
I have a date in A1 (Oct 18, 2007) and I know I can enter
=A1+2 and that returns a date of Oct 20, 2007
=A1-36 returns a date of Sept 12, 2007
That works for days.
How do I have Calc add or subtract months or years....
...Lisa
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
