Date Calculation (1 Viewer)

I need to create a field that will return a date based on a date field and a combo box ignoring weekends. Example - The combo box has a person's name. A date field has a contact date which a user would enter. Another field on a form would be for follow-up. I would select a person's name in the combo box and enter the date 04/19/2002 (friday), the follow-up field should display 04/23/2002 for two business days later. Please help!!!!

How about this:

=IIf(Weekday([yourdatefield],6)<4,[yourdatefield]+(5-Weekday([yourdatefield],6)),[yourdatefield]+2)

Please Help Me Experts

Date1: 22/06/2014
Date2: 12/01/2019
Answer= 4 Years 6 Months 19 Days
it is possible in Access Query

excel formula =DATEDIF(A2,C2,"y")&" Years "&DATEDIF(A2,C2,"ym")&" Months "&DATEDIF(A2,C2,"md")&" Days "

i need it in access query

Thanks in advance

Duplicate post

https://www.access-programmers.co.uk/forums/showthread.php?t=14045