Excel formula to incrementally increase a value by 1 every 365 day

  • Thread starter ScheduleMyAppointmentNow_Com
  • Start date
S

ScheduleMyAppointmentNow_Com

I need help with correct formula to take a starting date from one cell and
place a formula in another cell that will increase the number by one for
every 365 days.

Employment date 5/30/2010 - 365 days past, new cell shows value "1"
representing 1 year
Another year passes and the new cell automatically updates to show the value
"2" representing 2 years employment

Another 365 days pass I need the value of the cell to automatically increase
to "3"

I tried the IF functions with TODAY() function but don't quite have it
solved correctly.

Thanks for your help if you will please...
 
J

Jacob Skaria

Try
=DATEDIF(A1,TODAY(),"y")

or with error/blank cell handling...
=IF(AND(A1>0,A1<=TODAY()),DATEDIF(A1,TODAY(),"y"),"")
 

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

Top