Date Calculation

  • Thread starter Thread starter lilu123
  • Start date Start date
L

lilu123

Hello All,

Hopefully someone will be able to help me out with the followin
problem..

I am trying to design a form in word to track employee holidays.In m
form the user is requested to enter a start date and and end date.
want to add some formula which automatically calculates how many day
they are taking and then deduct that from the total of 20 days annua
leave which they are entitled to....any ideas would be greatl
appreciate it ...my headache is slowing getting worse!!

Thank
 
I have to admit I have no idea how to do that in WORD (it's not reall
made to do complex calculations and data tracking), but my husband ha
already built a database in Access that does exactly that. It's ver
user-friendly too. If you're interested, you're welcome to e-mail m
-- I'm sure he'd help you out.

(e-mail address removed)
 
If you have access to the software, I think you and your
firm would be better served if you designed your forms
and calculations in an Access or Excel database. I can
hear Excel screaming, "Use me! Use me!"

Good luck.
 
Let's assume your first date is gathered by a form field Text1 formatted as
a date field and that your second date is a form field Text 2 formatted as a
date field and has the calculate on exit flag checked.

At the place you want the result of the calculation, enter the following
fields (using CTRL+F9 for each pair of field boundaries)

{=(20-({REF Text2 \@ "yyyyMMdd"} - {REF Text1 \@ "yyyyMMdd"}))}


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
Back
Top