excel vba courses - test question

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses - Test question

excel vba courses - Test question

resolvedResolved · Low Priority · Version Standard

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?

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips


Server loaded in 0.09 secs.