Date formula

[afdmello]

I am preparing a spread sheet for validity of cards and the trainng details
If the card issue date is 14/12/2009 and is entered into a cell For eg D1
Can I have formula in a cell to calculate and come up as 14/12/2010 in E1 as
the validity of card is one year


Thanks as always
Afd

 

[Pete_UK]

Put this in E1:

=DATE(YEAR(D1)+1,MONTH(D1),DAY(D1))

Hope this helps.

Pete

 

[herochenna]

Visit www.ExcelGoodies.Com