Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Set up tracking schedule

I am trying to set up a tracking schedule for vehicle repair. I need to set
a time line to track initial work, when to order parts, when to schedule the
work etc. Basically I want column A to be the start or work request , all
the way to column J to be the start of work. In between will be target dates.
So A will be lets say 180 days from J. And in between A-J will be other
target dates that are critical to planning of the work and ordering parts.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default Set up tracking schedule

Simply enter the first date involved into a cell (A1) then other cells can
either base their dates on it, as
=A1 + 5
for 5 days after A1

or even on a second, calculated date:
in B1 perhaps is =A1+5 (5 days after date in A1)
somewhere else = B1 + 4 (4 days after date in B1 [9 days after date in A1])

Does that help any?

"Harlet Rider" wrote:

I am trying to set up a tracking schedule for vehicle repair. I need to set
a time line to track initial work, when to order parts, when to schedule the
work etc. Basically I want column A to be the start or work request , all
the way to column J to be the start of work. In between will be target dates.
So A will be lets say 180 days from J. And in between A-J will be other
target dates that are critical to planning of the work and ordering parts.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tracking Changes Mimi Excel Worksheet Functions 6 December 15th 06 06:04 PM
How to insert tracking numbers into my webpage for RMA tracking wiglady Excel Discussion (Misc queries) 0 April 4th 06 12:44 PM
Create patient schedule based on master therapist schedule PapaBear Excel Discussion (Misc queries) 8 October 12th 05 04:56 AM
Employee Tracking Schedule littlebit Excel Discussion (Misc queries) 1 October 4th 05 01:00 AM
tracking newbie1818 Excel Discussion (Misc queries) 0 May 5th 05 06:15 AM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"