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

formating cells

ResolvedVersion 2007

Charlotte has attended:
Excel Intermediate course

Formating Cells

How to get the number of days between two dates

RE: Formating Cells

Hello Charlotte
Thank you for your question

You can use a basic sum formula or a Datedif. I have attached a spreadsheet which demonstrates how to use these formulas.


If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Attached files...

DATEDIF.xls

Tue 31 Mar 2009: Automatically marked as resolved.

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.