Countif Tomorrow
Options
Hello there, I'd like to be able to count how many people are arriving today, tomorrow, and the day after based on an Arrival Date column in Smartsheet. For today, I simply use the =countif(Today()) formula. Is there a way to say today +1, today +2, etc.?
Best Answer
-
Never mind, answered my own question! You simply enter Today(1) for tomorrow, Today (2) for day after, etc.
Answers
-
Never mind, answered my own question! You simply enter Today(1) for tomorrow, Today (2) for day after, etc.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!