Google Sheets Formula Directory
Explore our comprehensive library of Google Sheets formulas with examples, use cases, and our interactive formula generator.
Showing 6 formulas in Date & Time
DATE
=DATE(2025, 2, 25)Creates a date from year, month, and day values in Google Sheets.
View formula detailsMONTH
=MONTH("2025-02-25")Extracts the month from a date in Google Sheets.
View formula detailsNOW
=NOW()Returns the current date and time in Google Sheets.
View formula detailsTODAY
=TODAY()Returns the current date in Google Sheets.
View formula detailsWEEKDAY
=WEEKDAY("2025-02-25")Returns the day of the week as a number for a given date in Google Sheets.
View formula detailsYEAR
=YEAR("2025-02-25")Extracts the year from a date in Google Sheets.
View formula detailsFormula Generator
Create custom formulas with our AI-powered tool
Can't find the formula you need?
Use our AI-powered Formula Generator to create custom Google Sheets 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
Transform Your Spreadsheet Experience
Join thousands of users revolutionizing their data workflows. Get access to premium tools and expert knowledge.