troubleshooting Question

Calculate Weeks in A "Fiscal Month"

Avatar of Graham Gibson
Graham Gibson asked on
Microsoft AccessVBA
8 Comments1 Solution465 ViewsLast Modified:
Our companies fiscal year starts on the last Sunday in July. Each month starts on the last Sunday of the previous month. I will be given a date and I will have to give the number of weeks in that "Fiscal Month". For example

Su      M      T      W      Th      F      S
August                                    
31      1      2      3      4      5      6
7      8      9      10      11      12      13
14      15      16      17      18      19      20
21      22      23      24      25      26      27
September                                    
28      29      30      31      1      2      3
4      5      6      7      8      9      10
11      12      13      14      15      16      17
18      19      20      21      22      23      24
October                                    
25      26      27      28      29      30      1
2      3      4      5      6      7      8
9      10      11      12      13      14      15
16      17      18      19      20      21      22
23      24      25      26      27      28      29

August and September only has 4 weeks. October has 5 weeks.  
I would prefer not to build a table for each fiscal year show the number of weeks for the month for the date given. I had thought of select case statements but I haven't been able to get my arms around this yet. Thanks for any help.

Graham
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros