hello,
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 certian year *only* .... sample data : 2011-03-28 2013-08-19 2014-07-02 2015-01-11 2016-05-30 for any year, let say 2011, gives me err510 =COUNTIF(A1:A50,DATE(2011,*)) any help is appreciated. F- -- 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
