Learning level
72/100
Learning level
72/100
Product version
1.0.1
Guide status
Stable
Sections
3
Work with current date/time and Excel-style serial dates in the VauSheet runtime.
What this guide covers
Quick facts
The runtime converts dates through an Excel-style serial epoch so date functions can interoperate with numeric date values.
TODAY returns the current date serial. NOW adds the current time as a fraction of the day.
DATE constructs a serial date; YEAR, MONTH and DAY extract date components from a serial value.