Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

how to use a date like "TODAY" in a function without listening for the time in that date?

I'm creating a todo list. I know I shouldn't but it I got so stuck on this that I really want to know the answer. At the bottom of my table I have a footer row in which I want to show the total number of tasks to be accomplished today and each time I 'tick' a checkbox in one of the columns used for checking off my todos, I'd like to see it decrease by 1. But apparently from what I found out through experimentation is that the "TODAY" keyword or function word is using the date AND time and only if the time is 00:00:00 AM. So how can I avoid the time to be included when filtering? I'd like to use TODAY because then each day it'll reset itself automatically. Thank you for your time and effort in advance.

Numbers version: 3.5.3.

OS X: El Capitan 10.11

iMac, Mac OS X (10.5.8)

Posted on Nov 30, 2015 5:03 AM

Reply
16 replies

how to use a date like "TODAY" in a function without listening for the time in that date?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.