EDATE function

[mrexcelrc]

Hello, I need help with this function. Is there a way for this function to factor in weekends and named holiday? In other words if that particular target date is a weekend the date will be adjusted to a weekday and if that particular target date is a holiday the date will be adjusted to the next good working day.

Thanks in advance.

 

[markmzz]

Barry Houdini and Aladin Akyurek,

Thanks for explaining the formula.


Mrexcelrc,

Sorry for the formula without explanation and thanks for the feedback.

Markmzz