LinkBack URL
About LinkBacks
Hi
I am trying to count all of the cells in a column that has a date that is less than todays date using this formula, however it will not work.
=COUNTIF(P:P,<TODAY())
thanks
Hi
I am trying to count all of the cells in a column that has a date that is less than todays date using this formula, however it will not work.
=COUNTIF(P:P,<TODAY())
thanks
Try:
=COUNTIF(P:P,"<"&TODAY())
Never use Merged Cells in Excel
That worked thanks you.
Last edited by rgirardi; 08-19-2011 at 09:58 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks