The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating a Spreadsheet that updates length of Service

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Creating a Spreadsheet that updates length of Service

Resolved · Low Priority · Version 2003

ReplyMon 22 Feb 2010, 12:06Delegate Louise said...

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

For upcoming training course dates see: Pricing & availability

ReplyMon 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.

Excel articles

· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· How To Use Filtering In Excel 2010
· Using The Excel Forms Toolbar To Spruce Up A Workbook
· Break The Mystery Of Code With Excel Macros
· How To Ensure You Always Make A Complete Data Recovery

Please browse our web site to find out more about
excel training program and other Microsoft training courses.

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

Styles flowing thru documents from the index page

» Forum post: Indexs / contents on word docs

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions