At 17:30 05/10/2016 -0600, F H Data wrote:
I have yyyy-mm-dd as my date format in Calc (libreoffice 5.1.5.2) .
I like to count number of cells for a certain year *only* ....
sample data :
2011-03-28
[...]
for any year, let say 2011, gives me err510
=COUNTIF(A1:A50,DATE(2011,*))
Ho, ho - you are making it up!
o In B1, enter =TEXT(A1,"YYYY") and fill down the column.
o Use =COUNTIF(B1:B50,"2011") .
Or:
o In B1, enter =VALUE(TEXT(A1,"YYYY")) and fill down the column.
o Use =COUNTIF(B1:B50,2011) .
Note that the column here suggested as B can be hidden or put away
elsewhere on the sheet or even on another sheet.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
