I've attached (I think) an old timesheet my company uses for our technicians. I need to create a new one based on this but I can't figure out the formula for the dates. When you enter the date in the "time period" field it changes the upcoming week to the current dates. Timesheet.xls Also, the spreadsheet is password protected and I can't find anyone that knows where it came from to get the password to update the contact info!!!!
Thanks!
Tiffany
hi Tiffany. it's probably just a simple "Date + 1", "Date + 2" & so on. but you can use this formula for easy pasting. put this in A9 & copy down to A15:
$B$7+ROW(A1)-1
for B9 to B15, probably:
=TEXT($B$7+ROW(A1)-1,"dddd")
or;
$B$7+ROW(A1)-1
same formula as A7, but right-click-> Format cells -> Custom -> dddd
The next 3 tables has to be the same as the above, and not continued to be pasted.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Perfect!!! Thanks so much!!
The attached file shows what those date formulae are likely to be.
Hope this helps.
Pete
Thanks! I'll keep both examples.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks