LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default Easy Question - Please help

Anyone -

I'm trying to count monthly data within a date range and am having trouble.
i have data listed by day. i converted the dates for each occurrence from
mm/dd/yyyy (ex. 2/28/06) to a custom format, mmm-dd (ex. feb-06), and then
did a countif function to count the data that fell under a given month. But
the countif function doesn't recognize the mmm-dd format even though it's
displayed in the cell. it only recognizes the original date format 2/28/06
even when it is not formatted as such.

is there anything i can do? the bottom line is i have a huge column of
daily data that i want to count and sum by month...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Easy VBA question Dallman Ross Excel Discussion (Misc queries) 2 August 6th 07 01:26 AM
Easy Question M&M[_2_] Excel Discussion (Misc queries) 3 July 24th 07 12:34 AM
Easy Question Bob[_8_] Excel Worksheet Functions 9 July 14th 07 03:50 PM
new user with easy question? not easy for me speakeztruth New Users to Excel 5 June 3rd 05 09:40 PM
easy question Dahlman Excel Worksheet Functions 3 April 1st 05 11:11 PM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"