LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Summing Number by Week and Month

Hello,
I have a file that contains reasons for errors in a process. Each row is
one error and contains info such as date, reason for error, etc. I would
like to be able to sum the number that occur per week and per month using
VBA code. Is there an easy way to do this? I have done it by adding a week
number, month number and year number and summing, but that seems a little
long winded.

Thanks.

Bill


 
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
Convert Week number into Month KT Excel Worksheet Functions 7 April 2nd 23 08:36 PM
Convert Week number to Month KT Excel Worksheet Functions 0 May 28th 10 12:48 AM
??Calculate week number of a month Jaylin Excel Worksheet Functions 3 January 11th 07 02:01 PM
how to get week number in month in excel ? ikin Charts and Charting in Excel 2 January 16th 05 05:54 PM
calculate month from week number ankman Excel Worksheet Functions 2 November 24th 04 01:27 AM


All times are GMT +1. The time now is 01:54 PM.

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"