Microsoft Office Forums Timesheet formula help

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2009, 12:41 PM
beardking beardking is offline Timesheet formula help Windows XP Timesheet formula help Office 2007
Novice
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.
Beardking
Attached Files
File Type: xls Time Sheet Test.xls (27.0 KB, 11 views)
Reply With Quote
  #2  
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
Novice
 
Join Date: Jun 2009
Posts: 2
Suzanne Sarah Mcallen is on a distinguished road
Default

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.

http://spreadsheetzone.com/templateview.aspx?i=109

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

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

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

Regards,
Chaitanya


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

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 10:56 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft