If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel formula to incrementally increase a value by 1 every 365 day
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... |
#2
|
|||
|
|||
Excel formula to incrementally increase a value by 1 every 365 day
Try
=DATEDIF(A1,TODAY(),"y") or with error/blank cell handling... =IF(AND(A10,A1=TODAY()),DATEDIF(A1,TODAY(),"y"), "") -- Jacob (MVP - Excel) "ScheduleMyAppointmentNow_Com" wrote: 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... |
#3
|
|||
|
|||
Excel formula to incrementally increase a value by 1 every 365 day
With startdates in A2 down
put in B2: =DATEDIF(A2,TODAY(),"y") Copy down -- Max Singapore --- "ScheduleMyAppointmentNow_Com" wrote: 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... |
Thread Tools | |
Display Modes | |
|
|