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

This will return the date based on the computer date:

=TODAY()

That will change every day!

You'll have to provide more detail on the pay period question.

--
Biff
Microsoft Excel MVP


"Sherees" wrote in message
...
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

If you want something like the 1st day of the current month, and the last
day of the current month, use:
=date(year(today()),month(today()),1)
=date(year(today()),month(today())+1,0)

Regards,
Fred

"Sherees" wrote in message
...
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