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

Originally Posted by Tegglet

I have given up trying to do this using formulae, it works alright until there are two receipts in one calendar month. I overcame the problem pro tem by entering the second date manually. I am now trying to do the job properly using VBA.

Moved from Excel Formulas & Functions