Formula to show which accounting period a specified date falls in
I have a procurement table which tracks our purchase orders and the date when the invoice [ERP Approved Date] is entered into our accounting system for payment. I run reports from this table each pe...
Amber, does the Period change year-to-year or is it always based on the Months regardless of the Year. Depending on this, you could do a simple formula; or you might need a table.