# I need to count orders per day in Monthly Logs.

#### megnin

##### Active Member
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.

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
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.

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.

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.

You could create an additional column using

=INT(A1)

or

=WMID(A1,1,1)+0

where A1 houses a date and time value.

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

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

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!!

On 2002-09-10 12:42, megnin wrote:
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

Replies
1
Views
168
Replies
3
Views
110
Replies
11
Views
824
Replies
1
Views
116
Replies
3
Views
84

1,214,253
Messages
6,118,502
Members
448,828
Latest member
Pebl

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back