TODAY (current date)

<< Click to Display Table of Contents >>

TODAY (current date)

Syntax:

TODAY()

Description:

This returns the current system date (without time).

The displayed value is dynamic, so it is automatically updated when the document is opened.

Note:

The result is a number – like all dates in a spreadsheet. PlanMaker automatically formats it in the date format MM.DD.YYYY so that it will be displayed as a date. You can use the options from the ribbon tab Home | group Numbergroup_arrow to adjust the displayed date format to your needs.

Example:

TODAY() results in 07/31/2018

See also:

NOW, CREATEDATE