98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating a Spreadsheet that updates length of Service
Creating a Spreadsheet that updates length of Service
Resolved · Low Priority · Version 2003
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
Mon 1 Mar 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Convert Text into NumberSome times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions |
