S
Sam
Hello All
I suppose you may have been asked this question a million times, however I
have a report that counts the number of days from a start date and end date.
I have a query set up and a very basic formulae to count these days I.E.
Date()-[DateOfStatus]. this counts the number of days from today and the date
of status. I would like this query to only count working days (I.E. Monday to
Friday)
I have seen several posts requesting assistance with calculating working
days and someone has replied with a lengthy code to place somewhere, however
I am not sure that this is what I need to do the job.
Can someone steer me in the right direction?
I suppose you may have been asked this question a million times, however I
have a report that counts the number of days from a start date and end date.
I have a query set up and a very basic formulae to count these days I.E.
Date()-[DateOfStatus]. this counts the number of days from today and the date
of status. I would like this query to only count working days (I.E. Monday to
Friday)
I have seen several posts requesting assistance with calculating working
days and someone has replied with a lengthy code to place somewhere, however
I am not sure that this is what I need to do the job.
Can someone steer me in the right direction?