Microsoft Office Forums Timesheet formula help

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 10-29-2009, 12:41 PM
beardking beardking is offline Timesheet formula help Windows XP Timesheet formula help Office 2007
Timesheet formula help
Join Date: Oct 2009
Posts: 1
beardking is on a distinguished road
Default Timesheet formula help

I have a very basic spreadsheet that I use to keep track of my hours at work. I have it set up in 5 day work weeks per tab. I have the calendar date at the top of each days column and I have the first day (monday) linked to the previous Monday ( i.e. =SUM('09.21.09'!B1+7) where 09.21.09 is the tab name for the previous week and I'm adding 7 days to the value of the date in field B1).

What I'd like to do is make it a little more automated. When I make a new copy of a blank timesheet tab, I'd like that formulate to automatically be directed to the previous tab, instead of having to link the formula each time I make a new tab. Does anyone know if this is possible?

I have attached a sample of the spreadsheet that I'm talking about.

Thanks in advance.
Attached Files
File Type: xls Time Sheet Test.xls (27.0 KB, 11 views)
Reply With Quote
Old 11-04-2009, 02:20 AM
Suzanne Sarah Mcallen Suzanne Sarah Mcallen is offline Timesheet formula help Windows XP Timesheet formula help Office 2003
Join Date: Jun 2009
Posts: 2
Suzanne Sarah Mcallen is on a distinguished road

Hi beardking,

I'm sorry that I can't help you with the formulas, but I can recommend you a good working hours timesheet for 5 days.

It can give an idea on how to create your own spreadsheet, I suppose.

Reply With Quote
Old 11-10-2009, 02:06 AM
Chaitanya_Sagar Chaitanya_Sagar is offline Timesheet formula help Windows Vista Timesheet formula help Office 2007
Join Date: Nov 2009
Posts: 6
Chaitanya_Sagar is on a distinguished road

Hi Beardking,

To my knowledge, it is not possible to look at 'previous' sheet just by using functions. But what you can do is to write code that will 'find out the current spreadsheet' and then look for 'previous' spreadsheet and get the date from there.

If I were you, I would do this manually as this is minor work (please correct me if I am wrong).


Last edited by Matrix; 11-16-2009 at 09:36 PM.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Timesheet formula help If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Timesheet formula help Formula assistance please blazzercat Excel 2 07-08-2009 08:45 AM
Timesheet formula help Range Formula aleksandr Excel 10 05-18-2009 12:14 PM
Help for formula dehann Excel 5 05-01-2009 10:44 AM
Timesheet formula help Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM

All times are GMT -7. The time now is 07:40 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd. is not affiliated with Microsoft