I want to set the program, so as all the payslips sheets, excluding some
sheets (nearly 30sheets) will automatically update payment date in payslip
with the computer date whenever i open that excel file.

I also have two more date columns apart from payslip date, that is paymnet
period i usually enter (say, 01/12/2009 to 31/12/2009) against payment
period, when i openmy file the programme should identify the system date and
change these dates too,

illustration
If I open my XL salary file today, my payslip payment date should
automatically show todays date and at the same time the payment period date
must show 01/12/2009 to 31/12/2009.
--
Life isa journey not a destination