Today Formula - outputting 1/0/1900

Copper Contributor

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.

2 Replies

@sheatherly 

Could you attach a sample workbook demonstrating the problem?

Do you have a circular reference?