Calculate the Date of an Item Based on the Date of a Similar Item in the Previous Month

Looks to me like the circular reference is because cell B4 is calling function PrevSheet(B4). This is the definition of a circular reference. Excel doesn't know your UDF is using the address, not the value, of B4.

Also PrevSheet is not in this file so I am getting a NAME error.