In my answer on the question Scripting Games 2007 Advanced PowerShell Event 3 and 4 , I used a formula the get the Chinese Year. But to get from a date to a Year would take much more work, as the Chinese Year do not start and end on the same day. (so