Forecasting a date based on working days.

[weilerdo67]

Hello, I hope someone can stir me in the right direction. I have a table that has a record that uses a Submittal date. I need to record a due date based on working days. So if I have a record that was created on 11/7/2024 and is due back 15 working days later ( 12/3/2024) so I need to create a calculated field in my table for that date. I have a report that will run that calculated the actual response date that it returned mini the due date to see whats late. I know how to do this in excel using an IF formula but cant seem to get it to work in Access.

Thanks in Advance for any help or if someone could point me to an example.

 

[June7]

And you want to account for holidays? That will require a table of holidays and VBA. This is a fairly common topic. Review https://www.access-programmers.co.u...dates-excluding-weekends-and-holidays.319475/

 

[Gasman]

Why do I have Deja Vu for this thread?
See Similar Threads at the bottom of this post. You would also need a Holiday table.

Even look in Sample Databases as I am sure @Pat Hartman has posted a DB with a lot of date functions.

Here it is . https://www.access-programmers.co.uk/forums/threads/sample-date-functions.238821/