Counting the number of cells that contain today's date

Options

Hello,

I have a range of about 15 columns in another sheet that I need to find out how many instances today's date occur. I am getting a 0 for the result. There are actually 2.

=COUNTIF({Date}, @cell = TODAY())

Not sure how I go about getting this to calculate properly.

As always, any assistance is greatly appreciated.

Sharon C

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!