Timesheet Formula

  • Thread starter Thread starter Nikki
  • Start date Start date
N

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?
 
Hi
probably yes but you may provide some more details HOW the data should
change
 
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!
 
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
 
Back
Top