Changing dates automatically with the computer date

  • Thread starter Thread starter Sherees
  • Start date Start date
S

Sherees

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.
 
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.
 
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
 
Back
Top