When doing the Today formula, the cell is outputting 1/0/1900. The Calculation Options is Automatic, and the File-->Options-->Advanced shows zeros. I need this to automatically input the current day.

sheatherly Could you attach a sample workbook demonstrating the problem?

Do you have a circular reference?

Forum Discussion

Copper Contributor

May 12, 2021

Today Formula - outputting 1/0/1900

When doing the Today formula, the cell is outputting 1/0/1900. The Calculation Options is Automatic, and the File-->Options-->Advanced shows zeros. I need this to automatically input the current day.

Formulas and Functions

2 Replies

Patrick2788
Silver Contributor
May 12, 2021
Do you have a circular reference?
HansVogelaar
MVP
May 12, 2021
sheatherly

Could you attach a sample workbook demonstrating the problem?