I have a worksheet with 21 dates.
Every 3 weeks, I have to update the sheets adding 3 weeks to each cell.
Is there an easy way to create a macro to automatically update all 21 cells?
Thanks
I have a worksheet with 21 dates.
Every 3 weeks, I have to update the sheets adding 3 weeks to each cell.
Is there an easy way to create a macro to automatically update all 21 cells?
Thanks
Just change the first date and have a formula in the rest of the cells =WORKDAY(A1,1)
Works great and simple...
Thanks
Great! Glad it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks