Better Sheets

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

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!

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

Creating A Dark Mode Theme | Announcing Dark Habits

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

How to Trigger Macros Daily

Automate your apps script and macros you can record.

Advanced

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()

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()

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

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

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()

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

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()

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()

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

Browse 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

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Creating A Dark Mode Theme | Announcing Dark Habits

How to Trigger Macros Daily

Ben Asks: How Do I Add 1 Month?

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

Announcing Sell Daily and How I Built Sell Daily

Building a Year Progress Clone

Can I Automatically Rename a Sheet based on a Date?

Daily Writer's Word Count Tracker

Get Sheets Wrapped 2024 | Your Year in Google Sheets

Free Education Expense Template

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