Macro to add date move 5 collums right add next working day date
Good Afternoon
What I require is a macro that will start in Cell B1 add the date 02/01/13 copy that to the next 4 cells to the right and then in the 5th cell put the next working day up 03/02/11 and then do this for the rest of the year in the same format. To do this manually will take a very long time. (if possible just the working days for the year not the weekends)
If any one could help that would be great.
Thanks
Do you want the 2/01 date in all five cells or do you want 2/01,2/02 etc?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Don't really need a macro.
1) Put 2/1/13 in B1:F1
2) Put this formula in G1 and copy to the right as far as you need. Format the cells as needed.
=CHOOSE(WEEKDAY(B1),B1+1,B1+1,B1+1,B1+1,B1+1,B1+3,B1+2)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks