Hey guys!! I was wondering if I could get some help with this model i'm building. Say, you purchase a product and it arrives 5 weeks after it has been purchased, how would you automate this in excel/VBA? I tried using the offset function but it isn't happening.

Look forward to hearing your idea's