Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Dates & Times< Previous | Next > 

 

Basic

 
Expand

 -

Getting Started

Step By Step

 -

Entering Dates

Step By Step

 -

Entering Times

Step By Step

 -

Default Formats

Step By Step

 -

Custom Formats

Step By Step

 -

1904 Date System

Step By Step

 -

Useful Dates

Step By Step

 -

Useful Formulas


 

Worksheet Functions

 
GoTo

 -

DATE - Returns the date as a serial number given the year, month, day.

GoTo

 -

DATEDIF* - Returns the number of units between two given dates.

GoTo

 -

DATEVALUE - Returns the serial number that represents a given date in text format.

GoTo

 -

DAY - Returns the day as an integer given a date serial number.

GoTo

 -

DAYS360 - Returns the number of days between two dates, based on 30 day months.

GoTo

 -

EDATE* - Returns the serial number of the exact date for a given number of months before or after.

GoTo

 -

EOMONTH* - Returns the serial number of the last day of a month before or after a given date.

GoTo

 -

HOUR - Returns the hour as an integer given a date serial number.

GoTo

 -

MINUTE - Returns the minute as an integer given a date serial number.

GoTo

 -

MONTH - Returns the month as an integer given a date serial number.

GoTo

 -

NETWORKDAYS* - Returns the number of days between two dates, excluding weekends and holidays.

GoTo

 -

NOW - Returns the date serial number of the current system date and time.

GoTo

 -

SECOND - Returns the number of seconds given a date serial number.

GoTo

 -

TIME - Returns the time as a decimal given the hour, minute and second.

GoTo

 -

TIMEVALUE - Returns the time as a decimal returned as text given a date serial number.

GoTo

 -

TODAY - Returns the serial number representing today's date.

GoTo

 -

WEEKDAY - Returns the day of the week for a given date.

GoTo

 -

WEEKNUM* - Returns the week number in the year for a given date.

GoTo

 -

WORKDAY* - Returns the date that is an individual number or working days before or after a given date.

GoTo

 -

YEAR - Returns the year as an integer given a date serial number.

GoTo

 -

YEARFRAC* - Returns the number of years as a decimal between two dates.


 

Advanced

 
More Details

 -

Creating a Time Sheet

More Details

 -

Advanced Techniques

More Details

 -

Office Online

More Details

 -

Knowledge Base


 

Shortcut Keys

 
 

(Ctrl + ; ) - Enters the current date into the active cell and applies the format "dd/mm/yyyy".

 
 

(Ctrl + Shift + ; ) - Enters the current time into the active cell and applies the format "hh:mm".

 
 

(Ctrl + # ) - Applies the Date format "dd-mmm-yy" to the selection.

 
 

(Ctrl + Shift + # ) - Applies the General number format to the selection. This can be used to display the serial number for a date.

 

 

Tools > Options

 
 

(Calculation tab, 1904 Date System) - Lets you change the starting date from the 1st January 1900 to the 2nd January 1904.

 

 

Related Topics

 
GoTo

 -

Formatting Numbers

GoTo

 -

Functions


 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top