Is there a formula or code or whatever to do this?

[Dr.Geekit]

I am attempting to build a spread sheet with a constant run of dates. Hmm explain that better.... Ok Let me see if I can past in an example here.

1
Janruary 26 27 28 29 30 31 *1
*2 *3 *4 *5 *6 *7 *8
*9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
February 30 31 *1 *2 *3 *4 *5
*6 *7 *8 *9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
March 27 28 *1 *2 *3 *4 *5
*6 *7 *8 *9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
April 27 28 29 30 31 *1 *2
*3 *4 *5 *6 *7 *8 *9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
May *1 *2 *3 *4 *5 *6 *7

Hey that worked!

Alright so that's done manually with a 1 entered manually at the start of each month and then every day afterwards is just =sum(previouscell+1) then manually when I hit x number of days in which is in the month I change the value to 1.

Manually I enter in the month on the right hand side.

Manually I enter in the year on the left hand side above Janurary, so what you see above here is Year 1 (as in 0001 AD), and the first day of the year was Friday the 1st. From that date on, I need to plot out exactly what date fell on what day of the week for the next 2,011 years.

I thought maybe if I did it manually I would eventualy see a pattern, and be able to copy and paste said pattern. However I have been doing this manually for 8 years (lol not literaly but I am on 8 AD), and it's taken me about 2 hours to do that much. At that date I should be able to finish the next 2002 years in roughly 250.25 hours lol. Which if I work on it for like 2-4 hours a day, probably a whole year give or take and adding in weekend breaks lol.

So is there a formula here that might help me out? I have to imagin there is, because I've seen people build calendars that have forumals in them, although i've tried to reverse engerineer them to get them to work here, however most calendars I've found only go back as far as 1900, and do not put them in the format I have above.

Thanks to anyone who can help!

[Dr.Geekit]

Ooh Kay, That did not come out the way it was pasted in it lol. So i'l try to draw out my own here so it makes more cense:

A B C D E F G H
1-Jan 26 27 28 29 30 31 *1


maybe that does more? If someone might know any idea send a PM and I can email you the spread sheet I'm working with, that might help.

[martindwilson]

don't try in the forum post a sample workbook instead thanks

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[royUK]

Your post does not comply with Rule 11 of our Forum RULES. If you require a thread or post deleted then please private message a moderator. Moderators can be found here

[royUK]

Your thread is being closed for non compliance with our rules. Please PM me when you have read the forum rules RULES and made the changes to your post accordingly, i will then unlock your post so you may continue with the thread!

Post Closed