Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steve j.
 
Posts: n/a
Default How do I get an anniversary date?

I am new to excell, I am sure this is a fairly easy one for all the experts
out there!

I have created a spreadsheet, that lists all of our employees. The employees
vacation time is based on the number of years worked. How can I automatically
update each year?

Say an employee was hired 4/1/02, for 2004 he receives 1 week of vacation,
next year 2005, he would receive 2 weeks of vacation. When I made the
spreadsheet, I just entered a column that shows the anniversary date with the
year 2005, but that means each year I would have to change that column for
every employee. Any suggestions?
--
Steve J
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 04:00 PM
Automatically enter date and time but only update once. PM New Users to Excel 3 January 21st 05 08:47 AM
Date issue between Windows and Macintosh version dlg1967 Excel Discussion (Misc queries) 4 January 19th 05 04:51 PM
How do I stop today() from updating date on saved spreadsheets? lionmark Excel Discussion (Misc queries) 2 January 4th 05 02:03 AM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 03:06 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"