Prev: Find & replace different years (part of the date)in a column
Next: Vlookup from different sheets
From: ScheduleMyAppointmentNow_Com on 31 May 2010 01:40
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...
From: Jacob Skaria on 31 May 2010 01:48
Try
=DATEDIF(A1,TODAY(),"y")

or with error/blank cell handling...
=IF(AND(A1>0,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...
From: Max on 31 May 2010 01:54
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...
 | 
Pages: 1
Prev: Find & replace different years (part of the date)in a column
Next: Vlookup from different sheets