I've been trying to update some old spreadsheets that add 30 days to a date to instead use workday to add 30 working days. I've managed to convert my old dates into the correct dates using workday however, when I do it in that order it completly messes up my pivot tables later. Is there a way of incorporating workday into the code below?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
workday help
- Thread starter chris54
- Start date
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 16,726
- Office Version
- 365
- Platform
- Windows
- Mobile
It might be worth you having a read of the link below on how to post code as I don't think that you will get much response with the images that you have posted 
Some sample data using the forums XL2BB add-in would also probably help to get replies.
www.mrexcel.com
Some sample data using the forums XL2BB add-in would also probably help to get replies.
XL2BB - Excel Range to BBCode
Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...
Upvote
0
