magnify
Home Topic as at date formula for calendar year sites

as at date formula for calendar year sites

Home Forums XLOne as at date formula for calendar year sites

This topic contains 0 replies, has 1 voice, and was last updated by  Penny Hamlett 3 years, 7 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #669

    Penny Hamlett
    Participant

    =IF(xlvar.PERIOD_TO<>12,”Closing balance as at ” & TEXT(DATE(2000+VALUE(LEFT(xlvar.LDG_ACT,2)),(xlvar.PERIOD_TO+1),1-1),”dd-mm-yyyy”),”Closing balance as at “&TEXT(DATE(2000+VALUE(LEFT(xlvar.LDG_ACT,2)),12,31),”dd-mm-yyyy”))

    Why this formula works. The last day of the month is always one day less that the first day of the next month and this is true for leap years too.
    Our ledgers are 13GLACT etc.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.