Calendar on a field on a form

Hello everyone,

I want to create a calendar or any other simple method to enter date ON A FORM (xls file attached). The field type (if fields on forms have types apart from text box) should be date and the default value should be today's date. I also have a spin button next to it for changing the date in the text box. Please mention the code to be given for that spin button. I have a day field after this which i want to populate dynamically when I enter the date with the added functionality that when I change say a Friday to Saturday, the date should change to six days in the past (no tomorrow). I want the data from the form to come into columns in a worksheet. I use excel 2007 on a windows 7 machine.

Thanks in advance.
Charles.

Hello Guru,

I am not very familiar with the rules here. Sorry! Should this question have been posted in another forum/sub-forum on this site? Please advise.