I have to calculate a person's number of dates he is out of office. It is for calculation purpose only. I have 16 unbound text boxes (date) in a form. 8 for Exit date from office and 8 for entry date back into office. I need to calculate how many days he was away from office in a month. He may have 8 or less entries in a month. So while adding them I need to deal with the blank text boxes also. I assume I need to use date different function for each exit and entry and then adding them all. Please let me know how to do this and how to deal with the null text boxes while adding them all.
Thanks for your help.
Thanks for your help.