Hi Eva,

This formula is looking at the 'gldates.END' field, which is the ending date from the fiscal calendar. The second part 'C12' indicates the 12th period for the current year. Surrounding with the DATESTRING function and the %Y parameter means only printing the year. So the result of this formula would be to print the year of the end of the 12th fiscal period. Is this what you want to get?

This formula will not affect any of your balances or financial figures. If you see what you feel are incorrect values, you'd need to let us know the formula in the cell where the dollar amount is, rather than the year formula.

If you are doing a balance sheet and want the balance as of the end of a period (selected from the toolbar), the formula would be =ADGET("gldata.BAL",{accounts})