weeknum

I'm looking for a formula that will let me see the current week of a rotation based on two dates. Basically, I have a sync date, and a new sync date with a set number of weeks in the rotation--say, 2-weeks, 4-weeks, 12-weeks (whatever) that a routing computer uses to send my technicians to...

I'd like to be able to sumif based on a certain criteria (vendor code in my case, here being ACM) plus the week number. In a seperate cell i'd like to sumif by this same criteria plus the entire month. See below: <colgroup><col><col><col><col><col><col></colgroup><tbody> Vendor Date WeekNum...

I download data from home office every week. I make a few edits and then need to save it a few times with different names for different uses later. My question this go around: Is it possible to have it save with the week number automatically updating each week? I thought this would work but I...

I have a Week Ending Date Ranges that follow every Sunday. My report has a box the user enters the Week Ending they want to see, then the report will populate the next 7 week endings to view report. So if the user enters week ending 3/17/12, the report will populate the next 7 weeks, I simply...

Hi I'm trying to create an Excel Gantt template that has week commencing across the horizontal axis (ie 2/1/12, 9/1/12) On the vertical axis based on each task I have the start date and end date (as actual dates (is 4/1/12 SD 10/1/12 ED) What I would like is for Excel to automatically...

can weeknum work with the week starting on saturday instead of sunday or monday? if not, what are my options?

I have an excel sheet for paychecks for total hours and i use the weeknumber function to total up paychecks that i should be getting and compare with actual, however the weeknum function that i use i can only get to start on monday or sunday, but i need the week to start over on friday how do i...

I am trying to make a column for week numbers that either needs to start on thursday or end on thursday, right now i have =WEEKNUM(A4,2) and i think i need to change the 2 but im not sure really appreciate the help!

I have a worksheet which records call data against users. In column A (from A2 down) there are user names, in column B (call type) and in Row 1:1 there are dates. e.g. <TABLE style="WIDTH: 231pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=306><COLGROUP><COL...

I have a spreadsheet where I get a forecast in monthly numbers, and I want to blow it out to weekly buckets using VBA. I have the Month, and the number of weeks per month. How could I compute the weeknumber based on these two items? I am at a loss. Thanks!

When I use the WeekNum function =WeekNum(A2,1) to pull the week number for a row of cells with consecutive dates excel is saying that Tueday is the first day of each week. What the heck is gonig on and how do I fix this? Excel seems to be off by two days - the clock in my windows task bar seems...