=TODAY() inserts the current calendar date into a spreadsheet calculation. The official ONLYOFFICE TODAY reference documents the exact zero-argument syntax TODAY() and describes a date displayed in MM/dd/yy format. Unlike typing a fixed date, this formula is intended to refer to the date at calculation time. The current date shown in a workbook will depend on when and where it is evaluated; no live result was observed in ONLYOFFICE for this guide.

=TODAY()

For an example that will remain numerically checkable later, use =DATE(2026,10,11) as a fixed testing date. Do not describe its output as a current result of =TODAY() on future dates.

Useful for rolling deadlines, age of invoices, overdue status, active project windows, and reports anchored to the day of review. It is a date calculation, not a timestamped audit trail or a permanent log of when a row was created. If you need an immutable entry date, type or import a fixed date and keep an audit process; do not rely on an automatically evaluated date formula.

The English formula spelling is =TODAY(). The vendor displays the current day in an MM/dd/yy style in the English reference; the display depends on regional and cell-format settings and must not be mistaken for a fixed text string. The documentation does not specify a precise per-platform source of time, midnight switch timing, or trigger frequency for every version. Check those behaviours on the editor you deploy. ONLYOFFICE TODAY help; Advanced Settings.

To avoid making a sample table expire, enter =DATE(2026,10,11) in B1 and label A1 Test as-of date (fixed). This is a training stand-in for TODAY, not TODAY’s observed result. Enter the following sample tasks in A4:B9; B column should contain actual date values created with DATE, not locale-dependent strings. In C4 enter =DAYS(B4,$B$1) and fill down. In D4 enter =IF(B4<$B$1,"Overdue",IF(B4=$B$1,"Due today","Upcoming")) and fill down.

These expected integers come from Python datetime.date subtraction, cross-checked with the fixed-date model due - as_of; the associated CSV contains exact inputs and expectations. The DAYS reference establishes DAYS(end_date,start_date), so a due date before the as-of date produces a negative difference. Whether a cell displays a numeric difference or a date depends on its number format; choose a Number/General format for column C.

After validating the fixed case, replace B1 with =TODAY(). Now column C is intended to show days until each due date, and D the current classification. The table above is no longer the expected output except when your evaluation date is exactly 11 October 2026. Record the editor version, region, workbook date system and clock context alongside any observation.

Important: =DATE(2026,10,11) is not a way to force TODAY to return that value; it is a controlled test fixture that makes arithmetic reproducible.

1. Days left to a single milestone. =DAYS(DATE(2026,12,31),TODAY()) is a rolling countdown. On the illustrative as-of date 2026-10-11, independently expect 81. On other dates its result intentionally changes; do not mistake this fixed demonstration for a native output.

2. Flag expired contracts. If cell B2 is an actual expiration date, use =IF(B2<TODAY(),"Expired","Current"). This treats an expiration today as Current. If business rules require expiration at the beginning of the date, change the comparison to <=—that is a policy decision, not a difference in the function’s syntax.

3. Keep blank rows blank. For a worksheet with occasional empty due-date cells, use =IF(B2="","",IF(B2<TODAY(),"Overdue","Not overdue")). This avoids classifying every unfilled date field as overdue. A blank formula result in B2 is not necessarily identical to an empty cell in other contexts; test your imported workbook.

4. A 30-day rolling review window. =IF(AND(B2>=TODAY(),B2<TODAY()+30),"Review window","Outside") selects dates today through 29 days ahead. If including the 30th day is intended, use <=TODAY()+30; state the boundary explicitly.

5. Find the current month number. =MONTH(TODAY()) combines two officially documented functions. If date-based summary reporting matters, this represents the current calendar month at calculation time, not a stored historical month.

Excel documents the same zero-argument signature, so the function name/syntax is a supported cross-reference. Excel’s official article also describes date serial formatting and recalc settings, but these Excel-specific remarks do not prove equal caching, timezone, refresh, or formatting behaviour in ONLYOFFICE. Test the actual imported workbook. If you need time of day, consult NOW() rather than asserting that TODAY() is a timestamp.

The Insert Functions guide documents English formula examples with an = prefix, function names and commas between arguments. The Advanced Settings guide documents Formula Language, Region, and a workbook 1904 date system option. If your interface uses another formula language or locale, check the actual function picker and pasted formula separators; do not assume the English spelling/display carries over. The 1904 system can change underlying date serials when transferring files; prefer DATE(year,month,day) for explicit-date examples, and verify workbook settings when importing.

• NOW: date and time, not date-only.

• DAYS: compute signed date differences using explicit end and start arguments.

• DATE: make fixed, locale-unambiguous test dates.

• MONTH: extract calendar month number.

• TODAY

• ONLYOFFICE Spreadsheet Editor — function documentation
• Advanced Settings
• DAYS reference
• officially documented functions
• Formula > Calculation control
• NOW()
• Desktop Editors changelog

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in ONLYOFFICE Spreadsheet Editor.

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.