find count of year from DateTime column

**linok** · 02-12-2015, 02:26 AM

Hello,

I need help in finding count of records from date time column matching with year.
please find attached sample workbook.

**:) Sixthsense :)** · 02-12-2015, 02:36 AM

In B2 Cell

=COUNTIFS($F$1:$F$9,">="&DATE(A2,1,1),$F$1:$F$9,"<="&DATE(A2,12,31))

Drag it down..

**linok** · 02-12-2015, 03:07 AM

Originally Posted by :) Sixthsense :)

In B2 Cell

=COUNTIFS($F$1:$F$9,">="&DATE(A2,1,1),$F$1:$F$9,"<="&DATE(A2,12,31))

Drag it down..

Out of curiosity I am asking one question:
What if Cell A1 to A3 is date time?

**:) Sixthsense :)** · 02-12-2015, 03:09 AM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**linok** · 02-12-2015, 03:18 AM

please find attached file

Originally Posted by :) Sixthsense :)

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**:) Sixthsense :)** · 02-12-2015, 03:32 AM

The expected results are same like previous or different one?

**linok** · 02-12-2015, 03:50 AM

yes it is same

**:) Sixthsense :)** · 02-12-2015, 03:56 AM

Try this...

In B2 Cell

=COUNTIFS($F$1:$F$9,">="&DATE(YEAR(A2),1,1),$F$1:$F$9,"<="&DATE(YEAR(A2),12,31))

Drag it down..

**linok** · 02-16-2015, 01:46 AM

I know I have marked it as resolved. but this fails for column with Date Time value

**linok** · 02-12-2015, 04:06 AM

Thanks for your help.

**:) Sixthsense :)** · 02-16-2015, 02:09 AM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

find count of year from DateTime column

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

find count of year from DateTime column

Re: find count of year from DateTime column

Re: find count of year from DateTime column

Re: find count of year from DateTime column

Re: find count of year from DateTime column

Re: find count of year from DateTime column

Re: find count of year from DateTime column

Re: find count of year from DateTime column

Re: find count of year from DateTime column

Re: find count of year from DateTime column

Re: find count of year from DateTime column

Thread Information

Users Browsing this Thread

Similar Threads

Trying to find a way to build a running count of the items with >2 failures in a year

Count Occurrences of time stamp bewteen two times from DateTime Column

[SOLVED] Count values in column, paste current year in another column that many times

Based on a Column datetime value auto calculate and populate a datetime range

[SOLVED] count cells with year sets in a column?

Bookmarks

Bookmarks

Posting Permissions