## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR Start((START)) --> EXCEL_DAY[EXCEL_DAY]:::quoted EXCEL_DAY --> End((END)) ``` ## Purpose The `EXCEL_DAY` SQL function gets the number which in Excel represents the date. The leap year bug of Excel is included, so the day number increments by 2 between February 28, 1900 and March 1, 1900. Parameters: - Date: datetime to get number for. Returns: the number which in Excel represents the date, with 1 meaning January 1, 1900.