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
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
