Deduct Months from a Date
Maybe
=DATE(YEAR(D1),MONTH(D1)-E1,DAY(D1))
Mike
"DaveMoore" wrote:
In Column 'D' I have a list of dates in the form MMMM/YYY
Column 'E' contains whole numbers which represent a no. of months
In column 'F' I wish to deduct the number of months in 'E' from 'D'
Can anyone help?
|