S
Sue
I wasn't sure if this question was best addressed under the heading of
"queries" or "reports", so have posted to both. Your help will be endlessly
appreciated.
Work has been quite stressful. I've decided to leave my current position. My
last workday will be July 3. I work 4 days a week. I have a command button
that pops up a little form that gives the number of days remaining until July
3rd. I also want to indicate the number of WORKDAYS remaining (assuming I
take no vacation, holiday, or sick time between now and then). The
calculation I have for that is:
=((DateDiff("d",Date(),#7/3/2008#))/7)*4
I suspect that this won't always be accurate, however, because the
calculation I'm using doesn't distinguish between workdays and weekends.
You have NO idea how much my stress level decreases when I click that
command button. Can you help me to ensure that my calculation is really
accurate, though?
Many many thanks!!!
"queries" or "reports", so have posted to both. Your help will be endlessly
appreciated.
Work has been quite stressful. I've decided to leave my current position. My
last workday will be July 3. I work 4 days a week. I have a command button
that pops up a little form that gives the number of days remaining until July
3rd. I also want to indicate the number of WORKDAYS remaining (assuming I
take no vacation, holiday, or sick time between now and then). The
calculation I have for that is:
=((DateDiff("d",Date(),#7/3/2008#))/7)*4
I suspect that this won't always be accurate, however, because the
calculation I'm using doesn't distinguish between workdays and weekends.
You have NO idea how much my stress level decreases when I click that
command button. Can you help me to ensure that my calculation is really
accurate, though?
Many many thanks!!!