Forum Discussion
VBA Code to Count Down Days
Hi All I want to create a message box that pops when someone opens an excel file and it should read: "Number of Days to Compliance: XXX" I can create the message box in VBA but don't know...
Thanks - you are a genius!
How can I amend the above to make it count only working days from TODAY(), as each day refreshes please?
The code subtracts Date from the target date.
Date is the VBA equivalent of TODAY(): it always returns the current date.
Oh wait - you want working days. Just a moment, please.