I have a workbook that contains expense reports. There is a worksheet for every pay period for the year. I have each tab name read the date of every pay date which is every Friday of the year. I created code that reads a worksheet that has all of the dates typed out and the code reads a cell and places that cell's content as the next worksheet's tab name.
I hate typing out the dates at the beginning of the year to calcuate all of my tab names. How can I code so that VBA figures out the date of every Friday and places those dates as my tab names?
I hate typing out the dates at the beginning of the year to calcuate all of my tab names. How can I code so that VBA figures out the date of every Friday and places those dates as my tab names?