calendar table

I have a large table in the form: <tbody> Months August September October November December August 112 A B C D September 118 E F G October 231 H I November 142 J December 253 </tbody> Which only has diagonal values corresponding to the months...

Hi, I'm trying to create a chart/calendar that shows which days/working days (probably need both) are available/not available. I have a table that has 15 clients, each with columns to the right, that contain pretty random dates 'XX/XX/XXXX' stored against them (so far September - December) I...

Hello, I recently started watching the amazing ExcelisFun power pivot videos by Mr. Girvin and have been having a blast learning about all of the capabilities and ease of use. I have two questions about the date table that I really need some help with. I've been searching the internet for a...

Hi there, I have a complicated excel problem, which I want to solve with formulas if possible. Basically, it's a forecasting tool that changes based on different launch dates. For example: Launch Date is April 2013, and the quantity in that month is a percentage of the total market (say 50)...

I have to create charts from calendar tables in Excel 2007 but the calendar has to be 12 months running. I January the calendar table reads the months Jan thru Dec across the columns. I February the table reads Feb thru Jan. JAN FEB MAR .... DEC for the first chart FEB MAR APR .... JAN for the...