Excel Calendar program to add vacation days

HI there,
I have an awesome vacation program, that has a dashboard to enter days and into the calendar.
It has worked great for 2016, and now we are getting ready for 2017. The only problem is that there 2 months that have 6 weeks (April and December) These two months do not show that last couple days in the 6th week line.
The VB of course needs to work when info is sent through the dashboard to the newly added days in the 6th week.
   
Thanks so much.
Chris
aprildec.JPGStripped-for-help.xlsm
chris pikeAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Change your formulas as per below
On April Sheet,
In F58
=DaysAndWeeks+DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1),(WeekStart="Mon")+1)+120

Open in new window

Confirm with Ctrl+Shift+Enter instead of Enter alone.

On December Sheet,
In F58
=DaysAndWeeks+DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1),(WeekStart="Mon")+1)+365

Open in new window

Confirm with Ctrl+Shift+Enter instead of Enter alone.
0
 
[ fanpages ]IT Services ConsultantCommented:
'Stripped-for-help.xlsm' is protected.
0
 
chris pikeAuthor Commented:
OPps

7989kerry

second password
vacation
0
 
chris pikeAuthor Commented:
You are a wizard.
Awesome work...
Thanks so much,
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Chris! Glad to help.
Wait... I am Genius now with level 26. Lol (just kidding)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.