Hi,
I am looking for a simple way to rename a tab to whatever the current week Friday's date is. Below returns the current date, but I am not sure how to make it specify the Fridays date. One thing is that the tab could be renamed at any point during the week.
ActiveSheet.Name = Format(Date, ("mm-dd-yyyy")
Any thoughts?
I am looking for a simple way to rename a tab to whatever the current week Friday's date is. Below returns the current date, but I am not sure how to make it specify the Fridays date. One thing is that the tab could be renamed at any point during the week.
ActiveSheet.Name = Format(Date, ("mm-dd-yyyy")
Any thoughts?