formating cells

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formating Cells

Formating Cells

resolvedResolved · Low Priority · Version 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.

 

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:

Use the Ctrl-key for quick navigation in Excel 2010

If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key.

View all Excel hints and tips


Server loaded in 0.08 secs.