- Calculate Age of a person
Different expressions and functions to correctly calculate a person's age
- Return a date in the future from a given date.
How to do basic date calculations
- Calculate differences in time
How to do basic date calculations
- Return Dates in US #mm/dd/yyyy# format
Work with international date formats
- Calculate Number of Working Days
How to correctly calculate number of work days (with
and without accounting for holidays)
- Various Date manipulation functions
Handy functions that return FirstOfMonth, LastOfMonth, NextMonth, LastMonth, and SetDayOfMonth
- How to handle midnight in calculations
How to correctly include midnight in date/time calculations
- Time, adding and subtracting time and timesheets
How does Access and VBA deal with Date fields and data type
- Determining Average Time
How to calculate Average Time by using two queries
- How many Sundays between two dates
How to calculate the number a specific day appears in an interval
- Doing WorkDay Math in VBA
Code from "Visual Basic Language Developer's Handbook" for information on the next and previous workdays, finding the first and last workday in a month, and deal with Holidays
