What is TODAY called in Spanish?

In Spanish Google Sheets it is HOY. The formula =B2-TODAY() is written =B2-HOY() (or with commas under a Mexico locale).

Why does TODAY use semicolons in some spreadsheets?

It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.

Google Sheets TODAY function

Returns today’s date and updates itself every day. In Spanish Sheets it is called HOY.

Syntax

English Sheets

=TODAY()

Spanish Sheets (Mexico locale)

=HOY()

Spanish Sheets (Spain, Latin America)

=HOY()

Example

TODAY() returns today’s date and updates every day. Subtracting it from a date gives the days left; a negative result means it is overdue.

=B2-TODAY()

Common mistake

The parentheses stay empty. Since it changes every day, do not use it for a fixed date: type it or press Ctrl+; .

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice TODAY

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/103

My spreadsheet is inGoogle Sheets functions in English and Spanish

Days until due with TODAY

TODAY() returns today’s date and updates every day. Subtracting it from a date gives the days left; a negative result means it is overdue.

Example=B2-TODAY()HOY = TODAY

In C2, calculate how many days are left until each invoice is due, counting from today.

	A	B	C
1	Invoice	Due	Days left
2	F-201	12/15/2026
3	F-202	01/31/2027
4	F-203	09/30/2026
5	F-204	03/10/2027
6	F-205	11/20/2026
7

Tip: while typing, click a cell or drag across several to insert their reference.

Frequently asked questions

What is TODAY called in Spanish?: In Spanish Google Sheets it is HOY. The formula =B2-TODAY() is written =B2-HOY() (or with commas under a Mexico locale).
Why does TODAY use semicolons in some spreadsheets?: It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.
What is the most common TODAY mistake?: The parentheses stay empty. Since it changes every day, do not use it for a fixed date: type it or press Ctrl+; .