I know working with dates in VBA can be tricky,
I have multiple workbooks in a folder that need to be opened and the due date checked. If the due date in cell A1 is 2 weeks prior to that due date i need to email a link to a team to complete some data validation. if the due date has been reached i want to email another team for their input. I hope this is self explanatory, let me know if you need any further details. I have the code for emails and i have the code to open and close workbooks in a chosen folder. But i do not have the code for the Due date, however is someone could do the whole thing i would be appreciative.