How to calculate days worked from start date

I am trying to write a query to work out the number of days my employees have worked since they started at the company and for the report have a column named DaysEmployed.

Any help would be greatly appreciated.

Visual Basic Classic

Last Comment

Gary Chalmers

8/22/2022 - Mon

GrahamSkan

11/30/2017

Do you want to work from a rule, such as counting all the days, subtracting weekends and bank holidays, or do you have attendance records in your database?

Gary Chalmers

11/30/2017

ASKER

Hi Graham. No requirement to subtract weekends and bank holidays. it is literally just to have a list of the employees and number of days the have been with the company

ASKER CERTIFIED SOLUTION

Fabrice Lambert

11/30/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Martin Liss