Please bear with my ignorance.
SOLVED
In MS-Excel 2007 dates seem to be limited to YYYY/MM/DD style, which I imagine there is a way to alter it into MM/DD/YYYY. I looked into MS Help, and a google search, and either I was using wrong keywords, or not, but I couldn't find anything to simply change date arrangement. If I am being unclear, I am talking about the function '=DATE(YYYY/MM/DD)' is what I want to change.
After I get that fixed, I need there to be a function to reproduce a 3-day work week (Mon, Tue, and Thur). e.g.:
10/05/09 [data] [data] [data]
10/06/09 [data] [data] [data]
10/08/09 [data] [data] [data]
Week 1 [data sum] [data sum] [data sum]
10/12/09
10/13/09
10/15/09
Week 2
10/19/09
10/20/09
10/22/09
....
And so on and so forth. I would have to experiment with the function, but I was thinking something that works with adding, per say, 6 cells above and adding 7 to the day listing (thus making it a week later). That would also I need (or hope) that the date function would automatically bump over to the next month.
Week 2 Week 3 ....
10/12(+7)/09 = 10/19/09 ....
10/13(+7)/09 = 10/20/09 ....
10/15(+7)/09 = 10/22/09 ....
And about the bump function, something like:
10/29(+7)/09 = 10/36/09
would automatically change to
11/05/09
I hope I am making sense here. I will do my best to rephrase anything that I can.
Thanks in Advance,
Jimmi G
Bookmarks