A company uses for reports the period from the 26th of the last month until the 25th of the new month. Example: November 2019 : 26 Oct - 25 Nov
That is not the standard period application are used to. Meaning in applications/ formula the month November runs from the 1st to the 30th.
I need a formula that puts the dates, like Dec 12 2019 automatically in the period December 2019.
And Dec, 27 2019 to period January 2020. How can we accomplish this?
In other situations I covered the days in the month based with the weeks. For example month December has weeks 49, 50, 51 & 52. But in this situation it needs to be more granular.
First I need a formula for Excel & later on also for Access.
How can we solve this with a formula?