Hi
i have a table with 2 columns. first columns is date and time. seconds is my records.
I want a auto-calculation, count out how many records i have today.
what should i do? i tried the =countif($A,today()), doesn't work.
someone help. million thanks
iMac, OS X El Capitan (10.11.3), null
You can do something like this:
=COUNTIFS(Table 1::A,">="&TODAY(),Table 1::A,"<"&TODAY()+1)
TODAY() gives the date-time string of last midnight. TODAY()+1 gives midnight tonight. The COUNTIFS counts all entries on or after last midnight and before the coming midnight (which is the start of tomorrow).
SG
You can do something like this:
=COUNTIFS(Table 1::A,">="&TODAY(),Table 1::A,"<"&TODAY()+1)
TODAY() gives the date-time string of last midnight. TODAY()+1 gives midnight tonight. The COUNTIFS counts all entries on or after last midnight and before the coming midnight (which is the start of tomorrow).
SG
you are genius! thanks a lot
Glad it worked. Thanks for the green tick!
SG
problem with date functions
