# Date functions

<table><thead><tr><th width="264">NAME</th><th>DESCRIPTION</th></tr></thead><tbody><tr><td><a href="date-functions/dateadd">DATEADD</a></td><td>Adds a specified number of days to the input date</td></tr><tr><td><a href="date-functions/datediff">DATEDIFF</a></td><td>Returns the number of days between two input dates</td></tr><tr><td><a href="date-functions/day">DAY</a></td><td>Extracts the day of the month from an input date</td></tr><tr><td><a href="date-functions/date.set">DATE.SET</a></td><td>Returns a date after changing the format</td></tr><tr><td><a href="date-functions/eomonth">EOMONTH</a></td><td>Returns a date specifying the last day of the month</td></tr><tr><td><a href="date-functions/fromexceldate">FROMEXCELDATE</a></td><td>Converts an input date to a excel format date serial number</td></tr><tr><td><a href="date-functions/month">MONTH</a></td><td>Extracts the month from an input date</td></tr><tr><td><a href="date-functions/now">NOW</a></td><td>Returns the current date and timestamp</td></tr><tr><td><a href="date-functions/period_range">PERIOD_RANGE</a></td><td>Returns an array of date ranges between two specified dates</td></tr><tr><td><a href="date-functions/today">TODAY</a></td><td>Returns the current date</td></tr><tr><td><a href="date-functions/toexceldate">TOEXCELDATE </a></td><td>Converts an excel recognized serial number to the equivalent date</td></tr><tr><td><a href="date-functions/year">YEAR</a></td><td>Extracts the year from an input date</td></tr></tbody></table>