Remember Me?

#1
May 31st 10, 06:40 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: May 2010 Posts: 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.

#2
May 31st 10, 06:48 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2009 Posts: 8,521
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.

#3
May 31st 10, 06:54 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 9,221
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Steve New Users to Excel 1 December 13th 06 06:19 AM Steve Excel Worksheet Functions 1 December 13th 06 03:18 AM Steve Excel Discussion (Misc queries) 1 December 13th 06 02:36 AM Slimmyy Excel Worksheet Functions 5 March 18th 05 01:26 AM Mark Jackson Excel Worksheet Functions 3 January 14th 05 08:49 PM

All times are GMT +1. The time now is 08:10 AM.