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 <[email protected]>
To: <[email protected]>
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: [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
>
--
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
