Questions & Answers for: Italdesign Formula date stam

Question about 1996 Formula

I need to add a year to dates on excel spread

I need to add a year to dates on excel spread sheet there are more than 440 diffrent dates....Please help? I assume that the dates you want adjust are in date form and are in regular columns (or rows)

Question about 1996 Formula

1 Answer

I need to add a year on a number of dates there is

I need to add a year on a number of dates there is more than 440 different dates. Is there a formula on excel that i can use and if there is what is it? Please advise? Try this: =EDATE(CellRef,12) ...