How many days between certain dates

Click the new text box, and press F4 to display the Property Sheet if it's not already displayed. The "d" tells Access to calculate the number of days as opposed to years, months, etc. If your text box is named something other than DueDate, substitute your actual text box name in the function arguments.

Learn more about expressions by reading Learn to build an expression and Add functions to Access expressions. For more about forms, see Create a form in Access.

Need more help? Expand your skills. Get new features first. A subscription to make the most of your time. Try one month free. Unknown end date. You can also use this calculator to find out what day will it be after a specific amount of time has elapsed.

To do that, input the starting date and the number of days between into the day counter. Imagine that you have a complicated project due at work. Today is July Your boss wants to check the progress 14 days before the end of the project.

Additionally, he expects the project to be finished by September To answer the first question, we need to subtract 14 days from the date of September If you input 14 days as the days between , and September 27 as the end date into the day counter, you will quickly discover that the progress check will take place on September Now that we know when the progress check will happen, we can calculate the number of days between dates of July 14 the start date and September 13 the end date. The result is 61 days - that's the amount of time you have left to work on your project.

You could also find the number of business days between two dates, to figure out how many days you need to work! Embed Share via. Table of contents: How to use the days calculator How many days between dates? Or if you want to choose a day in the week and count how many times it occurs in a given year, try out the How Many Days calculator.

Type in the number of days and the exact date you want to calculate from. If you want to find a previous date, you can enter a negative number to figure out the number of days before the specified date.