I need to count orders per day in Monthly Logs.

[megnin]

I have Monthly spreadsheets to log orders.
Col A is the date, name and order number columns follow.

With about 1000 orders per month I need to count how many orders are logged each day so I can compare Quarter End volume to other times of the month, etc.

The problem I'm having is the date in column A also has the time so instead of being able to list 40 of Jan 2nd I can only list 1 each of Jan 2nd 2:53:01, Jan 2nd 2:55:02, etc.

I also don't have the Analysis ToolPak add-in.

please email at megnin@nortelnetworks.com

Thanks in advance!!

 

[davers5]

If you change the date format of the date in the date column you'll be able to use the autofilter on a daily basis. Go to format-cells, the number tab and click date in the list box. Then choose a date that does not contain the time. This will not change the value of the date, it will only change how it is viewed and then you can use the autofilter on days.

Dave S.

 

[megnin]

Thanks! I need to create a pivot table so I need to count the orders by day in a formula. I've go 15 months of logs to get the data from.

Thanks again for your reply!

 

[Aladin Akyurek]

On 2002-09-10 12:15, megnin wrote:
Thanks! I need to create a pivot table so I need to count the orders by day in a formula. I've go 15 months of logs to get the data from.

Thanks again for your reply!

You could create an additional column using

=INT(A1)

or

=WMID(A1,1,1)+0

where A1 houses a date and time value.

WMID is part of morefunc.xll, an add-in you can download from

http://longre.free.fr/english/index.html

Now it should be possible to build the pivot table you need.

 

[megnin]

Thank you very much Aladin!!!!!
That =int(a1) did the trick.

Now is there a way to tell what day of the week each day is (there are no Sat., Sun.)?

Thanks again!!

 

[Aladin Akyurek]

On 2002-09-10 12:42, megnin wrote:
Thank you very much Aladin!!!!!
That =int(a1) did the trick.

Now is there a way to tell what day of the week each day is (there are no Sat., Sun.)?

Thanks again!!

Custom format the formula column as, e.g.,

ddd mm/dd/yy