The title pretty much explains it. A spreadsheet I use daily requires me to put a despatch date. The despatch date is always the next working day, for example - if it's monday, despatch date will be tuesday. The problem I have is that the next working day after Friday is monday, so how can I check if it's a friday and then insert monday's date?
This is what I'm currently using for just tomorrows date - Having to manually put in the date each friday:
ActiveCell.FormulaR1C1 = DateSerial(Year(Now()), Month(Now()), Day(Now()) + 1)
Cheers
Bookmarks