End of month dating period
Simply Brilliant and a great way towards that ever elusive Eternal Happiness.
The period end date is used to report your business activity at the end of a financial period.
- it is useful to generate your reports in order to establish your company’s position at the period end.
Well you needless worry about that, you can easily go over 12 and the DATE function simply returns the month using the remainder after the number has been divided by 12 and even adds the number of years it get’s from the division by 12 to the year argument.If you base your financial periods on calendar months, then at the end of each month (the period end) you would run your profit & loss account along with your balance sheet in order to see how your business is doing.