I am writing some VBA for Excel and I need to figure out the date for the current or upcoming Saturday
So if it's Friday, I need to get tomorrow's date (Saturday).
If today is Saturday then I just want today's date.
If it's Sunday then I need yesterday's date.
If it's Monday then next Saturday
I was wondering if there was anything in Excel or VBA that can help me accomplish this