VBA Code to detect change in fiscal year between dates
Any good ideas to solve the following problem using VBA? I have a staffing model that goes across fiscal years and I need to recognize when that happens. The user enters 2 dates and I need to populate a table, a column for each week within the date range. I am not sure how to recognize when the fiscal year changes, which is Oct. 1. The dates can span multiple years.
Last edited by miam; 07-25-2011 at 03:21 AM.
Re: VBA Code to detect change in fiscal year between dates
I would suggest posting a small sample of your data with what you have and what you want to get as result
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1