Mon 22 Feb 2010, 12:06Delegate Louise said...
Louise has attended:
Excel Intermediate course
Creating a Spreadsheet that updates length of Service
I am trying to create a spreadsheet that updates employees length of service automatically.
I know to use the formula =TODAY() which updates the date on the page everyday that it is opened but is there a way I can link this into another column that updates the length of service using their start date and the date from the TODAY formuna?
Thanks in advance for any help you can give me
Louise
Mon 22 Feb 2010, 16:57Trainer Anthony said...
RE: Creating a Spreadsheet that updates length of Service
Hi Louise, thanks for your query. Put the start date (say 01/01/10) into A2 and the following formula into B2
=(TODAY())-A2
Then format B2 into a number. This will give you the number of days between today and the start of employment and will update daily.
Hope this helps,
Anthony
