Numbers that self-increment when the year rolls over
Haven't explored where that formula mis-calculates,
but when I run the below test, The values are
generally understated by 1.
StartDate CurrDate YourFormula Using_Datedif
1/1/2002 1/1/2008 5 6
1/1/2003 1/1/2008 4 5
1/1/2004 1/1/2008 4 4
1/1/2005 1/1/2008 2 3
1/1/2006 1/1/2008 1 2
1/1/2007 1/1/2008 0 1
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"cht13er" wrote in message
...
On Apr 11, 9:36 am, JustSomeGuy
wrote:
One column in a personnel roster spreadsheet contains the number of years
each person has worked for the company. Is there a way to make this number
for each person self-increment (ideally on each person's hire date
anniversary) so the spreadsheet will remain accurate, year after year,
without a lot of manual updating?
Have a column with the person's start date e.g March 12, 2005, and
another column with this formula: "=YEAR(NOW()-(D6-1))-1900" (where
D6 is that person's start date) ... if you like, you can format the
column (Format-Cells-Custom) as "## "Years Employed""!
HTH
Chris
|