Excel Formula Directory
Explore our comprehensive library of spreadsheet formulas with examples, use cases, and our interactive formula generator.
Showing 6 formulas in Date & Time
DATE
=DATE(2023, 12, 31)Creating a date value from year, month, and day components
View formula detailsMONTH
=MONTH("2023-04-15")Extracting the month number from a date value
View formula detailsNOW
=NOW()Retrieving the current date and time that updates when the workbook recalculates
View formula detailsTODAY
=TODAY()Retrieving the current date that updates when the workbook recalculates
View formula detailsWEEKDAY
=WEEKDAY("2023-03-15", 1)Determining the day of the week from a date
View formula detailsYEAR
=YEAR("2023-03-15")Extracting the year component from a date value
View formula detailsCan't find the formula you need?
Use our AI-powered Formula Generator to create custom formulas for any task. Simply describe what you want to calculate in plain language.
Popular formula requests:
- Calculate the sum of values when multiple conditions are met
- Extract specific text between two characters
- Look up values across multiple sheets with fallback options
- Calculate business days between two dates excluding holidays
Unlock the Full Power of Sheet Alchemy
Get access to all our formula generators, script generators, and conversion tools with a free Sheet Alchemy account.