[FAQ000121]Is there any way to get the day of the week for a given date?¶
Q¶
To get the day of the week for a given date,
how should I do this?
A¶
You can use the WEEKDAY function, which returns the day of the week for a given date as an integer, just like in Excel.
For example, if you want to specify April 1, 2019
=WEEKDAY("2019/04/01")
"2" (Monday) will be returned as the result.
A list of functions available in CELF is provided below.