How do I create a report summing all the days of a week. I have a table with multiple Sundays with different numbers:
Example:
Day Total
Sunday 10
Monday 20
Sunday 30
Sunday 40
....the total is 100
I want my report to have Sunday one time, not 3x's with the total. The report should look like the following:
Sunday Monday
100 20
Lastly, how can I change a date in short format to a day. Example: 04/01/03 should change to Tuesday.
Okay, I have a quandary, and an hour of searching did not find it. Close, but no cigar.
In a cell (we'll say A1 for simplicity), I have the following example data:
1:00:43:46 - This is to equivocate to 1 day, 00 hours, 43 minutes, and 46 seconds. I would like to express this value in seconds only.
Now, I found other threads that say to multiply the Hours/minutes/seconds value by 86400, and that works for most of our entries. However, some employees' total utilization times go over a whole day (24 hours) during the week, and we need the same results for them.
Sooo....most of the employees will show up like this - 5:12:43
But some will show up like this - 1:00:12:53
I need both results to be converted into purely seconds. Any help? We're running Office 2007, but XP answers are welcome (if different).
Trying to come up with a spreadsheet for a home business. What i am trying to figure out is what days of the week a customer made a purchase off of date column. Want to have 2 columns, 1 the date of order, and 2nd column, day of the week.
I am also trying to figure out a way of have a column that calculates how many days it took to ship something from the data a purchase, 2 columns, both with dates, a third column is where it would say how many days it took, would love to be able to have it show 2 numbers (4/7). 4 being business days, 7 being total days, dont ship on weekends
thank you. look forword to your responses
jknyc
I have lots of data that is in relation to a particular week. ie
08/02/10
09/02/10
10/02/10
15/03/10
15/03/10
I want to count how many fall into each week commencing, so as per the example above
w/c 08/2/10 = 3
w/c 15/2/10 = 2
How can I do this???
Thanks
I have a chart that the day of the week is sorted so my chart reads from left to right:
Friday Monday Tuesday Thursday Saturday Wednesday. I need it:
Monday Tuesday Wedneday Thursday Friday Saturday
How do I do this. The data is also sorted and I can't find an unsort. Help
I have made a excel file for daily expenses.
for which I have made a column for date, day of week and expenses. for each day I have to enter the date and weekday newly.
Can I have some setting where I can Set the Date and Day of Week Automatically?
Hi,
I am using the following filter code to filter by date. It filters the column by yesterdays date, which works perfectly fine. BUT unfortunately, I need this to filter by the previous BUSINESS DAY. So for today (Monday) when I run the macro, it currently filters by Sundays date. When I really need it to filter by Fridays date.
Is there are logic that I can put into to filter by the previous business or weekday. Or for example if today is a Monday to revert to the previous Friday. Can someone help?
Rows("1:1").Select
Selection.AutoFilter
Selection.AutoFilter Field:=18, Criteria1:=Format(Date - 1, "m/d/yyyy"), Operator:=xlAnd
Thanks
Hi,
I want to calculate net business days between two dates,I have used networkdays() but its not giving desired result.
Hi,
I need to populate the field C9, in the sheet Summary, with a date that is 28 days from the current date and then 2 week days from the 28.
For example: Todays date + 28 days + 2 week days
My code so far takes the current date and adds 30 days to it. But I'm having trouble completing the entire forumla.
Code:
'Add Date Of Return
Sheets("Summary").Select
Range("C9").Select
Selection = Date + 30
Any help would be greatly received.
Thanks
Tubbsy
I have an 8 week rota and i am trying to create a year planner
with week beginning date say 04/01/10 with the week number of the rota so 04/01/would be week 5, 11/01/10 would be week 6, up to week 8, then return to week 1
