How to Use TODAY() in Google Sheets

Description

Returns the current date as a date value.

How To Actually Use TODAY() in Sheets

TODAY()

Try TODAY yourself

In cell A1, use the TODAY() formula to display the current date. The correct answer must show today's date in A1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Find the Start date of the Current and End date of the Current Month

We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.

EOMONTH() TODAY()

Ben Asks: How Do I Add 1 Month?

Member Ben asks how to add 1 month to a date.

Intermediate

CONCATENATE() EDATE() TEXT() TODAY()

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.

Beginner

FILTER() HYPERLINK() IF() INDEX() MATCH() +3 more

How to Trigger Macros Daily

Automate your apps script and macros you can record.

Advanced

TODAY()

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Free Education Expense Template

Get this free education funding template I use myself. I use it and enjoy it. Thought you would too.

FV() JOIN() SUMIF() TODAY() YEAR()

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!

GOOGLEFINANCE() INDEX() SPARKLINE() TODAY()

Building a Year Progress Clone

Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.

EOMONTH() HOUR() MONTH() NOW() SPARKLINE() +3 more

Daily Writer's Word Count Tracker

Walk through creating an awesome automatic word count tracker that's easy to use and motivates the writer to keep going. With AI generated quotes from famous writers, along with simple formulas to generate states along the way.

Intermediate

CONCATENATE() COUNTIF() ROUND() SUM() TEXT() +1 more

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.

Intermediate

DAY() MONTH() TODAY() YEAR()

Get Sheets Wrapped 2024 | Your Year in Google Sheets

Get this free review of your Google Sheets in 2024.
https://bettersheets.co/sheetswrapped

Beginner

DATEDIF() TODAY() YEAR()

Transcript-matched member videos for TODAY(). Click through to watch.

Watch more tutorials

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including...

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Unlock these tutorials

Learn more about the TODAY() formula:

Generate a TODAY() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses TODAY(). 2 free AI generations, no signup. Members get unlimited use.

Generate a TODAY() formula

How to Use TODAY() in Google Sheets

Try TODAY yourself

Find the Start date of the Current and End date of the Current Month

Ben Asks: How Do I Add 1 Month?

Announcing Sell Daily and How I Built Sell Daily

How to Trigger Macros Daily

Creating A Dark Mode Theme | Announcing Dark Habits

Free Education Expense Template

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Building a Year Progress Clone

Daily Writer's Word Count Tracker

Can I Automatically Rename a Sheet based on a Date?

Get Sheets Wrapped 2024 | Your Year in Google Sheets

More related tutorials

Google Sheets Interface Changes

Hardest Formula: SumIF | Addition Based on Dates / Values

Google Sheet Basics - The Absolute Basics

Write Apps Script to Create a New Google Sheets Formula