Excel Question

A starting point would be on the overhead menu. Pick:

File
Page setup
Header/footer
Custom Header
With cursor in the section you want the date, select the calender icon.

This will print the current date - also time, if that's what you want. Whether you can tease it into producing prior and future dates, or not, I don't know. Also, any time you reprint the document, it is going to cough up the current date, not the date you created the thing.

Don't know if this is going to help or not.

Thanks Roger, that helps a little bit. Hopefully someone still knows if there's a way to do the rest of the dates.

Re: Excel Question
















Grrr, I got as far as "last sunday" and started hacking out a formula, till I noticed you said it would always be -6.



This one was difficult.



It basically, it finds out what the first day of the current month is, then it finds out what the first saturday of the month is, then it checks to see if today is the first saturday of the month.

If so, it prints "month-1" and the year.

If not, it prints month and year.

I did not get it to do years like "04" because excel uses years like "2004". So it would make periods like "82004".

If you really need it to be formatted like "0804" then use this formula (only works for post 2000 years).







Regards

PS. thanks for asking this question, it made me learn as much as you did.

PPS. if your boss ever gets on you for surfin' a2k, show them this thread. When my ole boss saw how many work answers I got through a2k he told everyone in the company to use it as their homepage.

Re: Excel Question
Cool, thanks Craven de Kere. That helps a lot!

Re: Excel Question


Right:) This site does have some work related value. We're allowed to use the internet for this kind of stuff. It's when I talk politics or play around that they don't care for so much.

Thanks a lot for the help. I've asked this before on other sites but never got an answer before.

My pleasure. It was fun figuring out the tough one.

Excel Timesaver
I'm not sure if you've already done this, but you could save a whole lot of time by creating a template and just using it everyday. You didn't say if you have to save these everyday or just print them and delete them, but either way it would probably be a lot more efficient. It seems like it would be especially useful because you'd only have to input the formulas that Craven de Kere gave you one time and if you have to make any formmatting changes to the data you add daily you can just format the empty cells where your info will go before you save it.