Microsoft Access Date Calculation

Apr 22, 2011
Reaction score
I am a bit of newbie to Microsoft Access but I am trying to put together a form that autocalculates some dates.

We have various dates that play off of each other. I have a "received" date and an "earnest money due by" date. I need the Earnest money date to always be 3 business days after the received date.

Then I have an "acceptance" date, an "expiration" date and a "warning" date. We also have a "life" field that gives you the choice to put 20, 45 or 60 days. The formula I need for this one will take the acceptance date and add the "life" days to it and display the answer as the expiration date. But the expiration date can't fall on a weekend. So if it is a Saturday or a Sunday I need it to back the expiration date up to the prior Friday.

Then I need the "Warning" date to be 15 calendar days before the "expiration date" again, not falling on a weekend.

I have tried various different formulas I have found online but I am really struggling to get it just right. Can one of you with minds immeasurably superior to mine help me out?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question