Formula

  • Thread starter Thread starter Ashish
  • Start date Start date
If you mean something like: A1 has a date and in B1 you want the date for
following year then
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula to update itself automatically. 10
how to calculate hrs flown in last one year 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Add one year in second combobox in vba 0
Expanding Date formula 1
Excel Help to copy information from one row at a time to another sheet 1
Excluding leap days in a formula 7
Dates for European Summer Time 6

Back
Top