Formula for Countdown

@SPark

Hi,

I've read through a few threads and I am unable to re-create a simple countdown formula. I keep getting an #INVALID OPERATION error. 

Am I missing something? Please help! Thank you! 

Andrée Starå

Hi,

Are both the Target Date and Today formatted as Date column types?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

@SPark

Yes, both columns are Date types. 

Andrée Starå

That's strange!

It should work.

Try to change the columns to text and back again and also try to edit the formula and then change it back again. Maybe it's a glitch. 

Did it work?

@SPark

Yes!! That fixed it!! I seriously thought I was going crazy! 

Thank you so much for your suggestion, I knew it had to be something simple! 

Andrée Starå

Excellent!

Happy to help!

(I starred at it for a long time as well)