Solved

# Converting weeks to Quarter

Posted on 2011-09-13
531 Views
I would like to setup a excel file that can help me display high level visual schedule for any particular project. I would have my high level tasks in rows and column would represent week number and quarters. my plan sometime goes beyond a single year. what i need to do is following:
Input a year which will populate week number in columns (52 columns)
convert these week number its month depending on particular year
convert a month into quarters for that particular year

so my file should look like following

2011
Q1
J J J J J
1 2 3 4 5
Sample.xlsx
0
Question by:dharmesh_a
• 2

LVL 50

Expert Comment

ID: 36533879
Hello,

I'm not quite sure what you want to automate. In any year, if the first week starts with 1-Jan,  the quarters each have 13 weeks.

Take a look at the attached. The week numbers and the months are populated by formulas. The core reference is the year in row 1. But no matter what year is entered there, the pattern of quarters, months and weeks does not change.

cheers, teylyn
Sample--1-.xlsx
0

LVL 50

Accepted Solution

teylyn earned 500 total points
ID: 36533908
correction: in leap years, the third quarter is one week longer. See attached with conditional formatting for the quarters and months.
Sample--1-.xlsx
0

## Featured Post

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity anâ€¦
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

#### Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!