Working with date data

D

Dudley Wright

I have a spreadsheet with the following type of data regarding leased equipment:
In column A, starting in A2 is the Lease Start Date
In column B, is the term of the lease in the number of months

I need to calculate the following:
In column C I would like to display the month that the lease term expires
And in column D the exact date of lease expiration
Data example:
A2=3/7/04
B2=42

If this is possible, I would be appreciative of some guidance.

Dudley
 
F

Frank Kabel

Hi
for both C2 and D2 try
=DATE(YEAR(A2),MONTH(A2)+B2,MIN(DAY(A2),DAY(DATE(YEAR(A2),MONTH(A2)+B2+
1,0))))

in C2 format the result with the custom format
"MMMMM"

Format D2 as date
 
Top