Excel - Date Time

Card Puncher Data Processing

About

Excel has only one time data type, it's a timestamp.

Functions

Date

=DATE(Year;Month;Day)
=DATE(2017;1;1)

Addition, Minus

=DATE1+2
=DATE1-1





Discover More
Card Puncher Data Processing
Excel - Datatype

This article is a generic article which talk the Excel datatype. The following table shows how Microsoft Excel driver data types are mapped to ODBC SQL data types. The Microsoft Excel driver assigns...



Share this page:
Follow us:
Task Runner