fiscal calendar

Hello All, Happy Monday. I'm hoping someone can help me with this issue here. I've attached two images so you understand what I mean. Basically, our first week of the year in 2019 started in in 2018. That's how I group the week (7 days starting 12/31/2018). Then, when I group them as quarter...

Hi, I am doing a piece of work with one of my customers data, unfortunately they do not use a standard calendar the financial year is between 29th June 18 - 27th June 19. i have attached a link to the excel spreadsheet with the week commencing date / Month and period number. if anyone knows...

I work in grant budgeting and need to calculate fiscal year budgeted amounts based off of calendar year budgets. Usually the amount of calendar year days hits multiple fiscal years. See below; <tbody> Calendar Year Total Days Fiscal Year Total Days Days in CY 365 350 0 715...

I know I should be able to do this with Excel, but can never get this to work. It involves 2 worksheets within a workbook. The first sheet contains dates and I want it to return the fiscal month for the date. The second sheet contains the table for the fiscal months. The second sheet is to use...