Re: [libreoffice-users] COUNTIFS with cells of yyyy-mm-dd

I was able to get this to work as I understand it?

                                                            03/28/11


                                                            08/19/13


                                                            07/02/14


                                                            01/11/15


                                                            05/30/16


                                                                   1
"=COUNTIFS(H1:H5,">="&DATE(2015,1,1),H1:H5,"<="&DATE(2015,12,31))"



I put the dates in column H in rows 1 to 5. (I have a actual date fields in 
MM/DD/YY format.

Had to use the COUNTIFS instead of COUNTIF, since had to get the range. 
Don't know if it would be possible to get the =(year) of the cells without 
creating a second column with that?
Then set the two criterians to find matching values.

=COUNTIFS(H1:H5,">="&DATE(2015,1,1),H1:H5,"<="&DATE(2015,12,31))

Other option was to put in I1-i5 =year(h1) ti =year(h5), and then 
=countif(i1:i5,2015) works.




On 5 Oct 2016 at 17:30, FHDATA wrote:

Date sent:              Wed, 5 Oct 2016 17:30:56 -0600
From:                   FHDATA <fhdata@unm.edu>
To:                     <users@global.libreoffice.org>
Subject:                [libreoffice-users] COUNTIFS with cells of yyyy-mm-dd 

> 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: users+unsubscribe@global.libreoffice.org
> 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



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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