Timesheet Formula

[Nikki]

I have an excel timesheet with fields that need updated.
We pay every two weeks. I have three fields: Check date,
pay week beginning and pay week ending that change every 2
week. I would like to make these cells update
automatically so that I don't have to send a new copy out
every two weeks. Is there a way to use the Today function
and some mathmatical formula that will update this?

 

[Frank Kabel]

Hi
probably yes but you may provide some more details HOW the data should
change

 

[Guest]

For instance the cell labeled check date says 10-15-04 when I send out the
sheet. The next week I change it to 10-29-04( two weeks later) and send it
out again. I would like to be able to make a template that I could put out
in a folder and for it to just automatically change to 10-29-04, 11-5-04,
11-12-04 etc... So I don't have to go in and manually change the date.
Currently, I just type the actual date in the field there is no formula. The
other two cells are "week beginning" and "week ending". They currently
say-9-19-04 and 9-25-04(there are also another pair of these for the second
week -9-26-04 and 10-2-04). Basically, right now these fields all need
updated for every new pay period. So I update them and email them to all the
hourly employees. If they would automatically update, I would only need to
email everyone a template once and they could use that over and over. I
figure that if it is possible it is a matter of an equation that I am not
thinking of- something like if today=10-15-04 then add 14. But the next week
that if today equals 10-15 would need to say 10-29? So that's where I am not
sure how to work around that. Thanks for the help!

 

[Frank Kabel]

Hi
i would start with using the TODAY() function for an automatic update.
Though this will change also the other files after saving an re.opening
them. I think this can't be achieved with formulas alone but would
require VBA