Changing dates automatically with the computer 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.
 
T

T. Valko

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.
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top