About this document

Comprehensive Excel Training Guide by Ioana Dobre is a document available to read on EtoBox.

Here are the key functions for working with dates and times in Excel: DATE: - Returns the serial number of a particular date - Has arguments: year, month, day TIME: - Returns the serial number of a particular time - Has arguments: hour, minute, second Other common date/time functions: - NOW() - current date and time - TODAY() - current date - YEAR(), MONTH(), DAY() - extract parts of a date - HOUR(), MINUTE(), SECOND() - extract parts of a time So in summary, DATE and TIME allow constructing dates/tim

Author

Ioana Dobre

Language

EN