Search

Learn excel formulas today date

TODAY

excel date today

 

What Does It Do?

Use this to show the current date.

Syntax

=TODAY()

Formatting

The result will normally be displayed using the DD-MMM-YY format.

Example

The following example shows how the Today function is used to calculate the number
of days since a particular day.

excel formula for date today
Note that the result is actually the number of days before todays date. To calculate
a result which includes the current date an extra 1 will need to be added.

excel formula for today's date

Example

The following example shows the number of days from today until the year 2000.

excel formula to count days from date to today
Share this article :
Facebook
Twitter
LinkedIn

Leave a Reply