The TODAY function

Returns today’s date.

In German Excel: HEUTE

How to write it

=TODAY()

💡 It updates every day. Subtract a date from it to get days since.

Try it

How many days ago was order 1005 placed? (Today is June 2, 2025 here.)

E6

A

B

C

D

E

1

Order

Customer

Ordered

Delivered

Days ago

2

1001

Kim

3/3/25

3/7/25

3

1002

Ali

3/10/25

3/11/25

4

1003

Kim

4/2/25

4/9/25

5

1004

Jo

4/15/25

4/18/25

6

1005

Ali

5/20/25

5/23/25

TODAY() minus the order date.