Log In
Register
Home
November 15, 2017
Offline
My company recently changed from a four week accounting to a monthly accounting format. We have been using the attached tracker for quite a few years.
Now with a month calendar there will be at least one week on this sheet with an odd # of days. My question is:
Is there any way to tie this sheet to a calendar or possibly to change the odd week depending on that month it is to the correct days depending on which month and year it is and clear out the remaining days for that particular week? This might take some VBA, but I'm not sure.
Any help would be much appreciated. Please see attached sheet.
Thanks,
Ken Mc
July 13, 2016
Offline
Hi Ken,
Looking at the attachment, you still have 5 weeks listed on the sheet and so when you drop down, say, October the sheet would allow you to have 4 full weeks of data plus 2-3 days of other data in the 5th week - or were you always cutting off at 4 weeks and adding in a full 5th week in every 3rd month or similar?
You will be able to govern the number of weeks and which days are counted in which month if you want to sit outside the boundary of the actual months (eg October 29-31 are part of November week 1) but are you being asked to report specifically per calendar month?
If the latter, there are a couple of things to consider:
1) What is it that your sheet is doing that you want "cleared out" for the non full week? It can certainly be done but if you can provide some more specifics it would be helpful.
2) Each calendar month will start on a different day of the week. Does it matter that you will no longer have the Thursday - Wednesday pattern and was there a reason for using this pattern that governs how we should look at a monthly version?
Cheers,
Adrian
November 15, 2017
Offline
Thanks Adrian,
I was able to get a fix from a fellow I'm taking a course from. I got my sheet all set up now. It required a bit of set up and quite a few formulas, but we go it done.
Thanks again sir!
Best,
Kenny Mc
1 Guest(s)
