Thu 17 Jan 2008, 16:37Delegate John said...
John has attended:
Excel Intermediate course
Test question
How do you input a formula that will keep track of the date from a given date placed in the spreadsheet. Say to keep an automatically updating track of how long an employee has been with a company?
Tue 29 Jan 2008, 14:57Trainer Carlos said...
Calculate difference in dates
Hi John
What you want is to find the difference between two dates. So as an example:
If your employee joined the company on 23/05/2004 (In cell C5), and you want to know how many days he has been with the company, the you subtract his start date from today's date.
So in the cell where the answer is to go you write
=Today() - C5
The Today() function will always use today's date from the computer.
Hope this helps
Carlos
