Attached is my little project that has been I have been working on for days. Ironically, what I need to do is easy.... But I also want dates that auto update correctly, but only for workdays, no sats or suns.
The dates I'm concerned about are in the B column. (Heck provided I get this figured out, I wouldn't even need the A column, and the sheet would be all the better for it)
So for example, say Sunday is the 1st.... I want the first entry (Monday of course) to read 2nd.
Can anyone help me please?
Thank you for saving my sanity once again.
Almost forgot! This if for Excel 2003
Edit: Oh, just noticed, while playing with this before, I added A1 as Year, and B1 as Month ... then used those for reference cells... I did some other stuff and confused everything, so never saved. I reuploaded the file to reflect that change
Bookmarks