Recent content by AK78

Works like a charm !:D Thank you mate for the great help. :)

I can use that for calendar year / month, no issue. But the accounting period i have is not on calendar basis. Not sure why, my attachment cannot be opened by myself. :banghead: The accounting period will read something like this in dd/mm/yyyy. FromTo AccYear AccMth 1/1/15 31/1/15 2015 1...

Hi all, I'm pretty much an Excel user and been using vlookup for dates. Basically, i have a table ("Transaction") with payment date and another table ("Control") with accounting dates and corresponding year/month. Objective: I need to know which accounting year or month these payment date...