XL.DateToTicks function: convert date and time values to ticks

How to use DateToTicks function for Excel: formula and results
XL.DateToTicks function – Date and time function type – returns the number of ticks that represent the specified date and time.

For example, the date March 10, 2021 will be represented by 637509312000000000 ticks.

A single tick represents one hundred nanoseconds, or one ten-millionth of a second. There are 10,000 ticks in a millisecond and 10 million ticks in a second.

Ticks represents the number of 100-nanosecond intervals that have elapsed since 12:00:00 midnight, January 1, 0001 in the Gregorian calendar.

Before you begin, add Functions to Excel

Functions are one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.

Get started with XLTools ribbon
– free trial gives you 14 days of full access to all features.

Syntax

=XL.DateToTicks(date)
ArgumentDescription
date
[required]
An expression representing the date and time value

Examples [download]

Download this spreadsheet with examples and try the function yourself.


FormulaDescription
=XL.DateToTicks(TODAY())Converts TODAY() to ticks
=XL.DateToTicks(NOW())Converts NOW() to ticks
=XL.DateToTicks(A4)Converts the date in cell A4 to ticks

Any questions or suggestions?
How can we help?