Excel

Resolved · Low Priority · Version 2007

Tue 15 Sep 2009, 16:31 Delegate Eileen said...

Eileen has attended:
Project Intro Intermediate course
Word Advanced course
Excel Intermediate course

Excel

How do you enter dates in excel

Wed 16 Sep 2009, 11:09 Trainer Andrew said...

RE: excel

Hi Eileen

Thank you for your question.

Excel will spot that the value you are entering is a date as soon as you press Enter or click somewhere else on the sheet.

You can modify the format used for your date by right clicking on it choosing Format Cells and from the Number tab choosing the date category. There you will find a selection of date formats that can be applied.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Tue 22 Sep 2009: Automatically marked as resolved.

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips

Excel

Excel

RE: excel

Excel articles

Excel tip:

COUNT function vs COUNTA function