TODAY Function

Purpose

Returns the current date.

Syntax

=TODAY()

Example

=TODAY()

Result will automatically show the current date.

Real-World Uses:

  • Today’s attendance
  • Due-date tracking
  • Age calculation
  • Expiry tracking
  • Daily reports

NOW Function

Purpose

Returns the current date and time.

Syntax

=NOW()

Example result:

28-Sep-2026 11:30 AM

The displayed value depends on the current date and time.

DATE Function

Purpose

Creates a valid Excel date from separate year, month and day values.

Syntax

=DATE(year,month,day)

Example

Year

Month

Day

Date

2026

9

28

  

Formula:

=DATE(A2,B2,C2)

Result:

28-Sep-2026

Practice

Create a Birth Date Calculator using separate Year, Month and Day columns.

PreviousNext