Question about Microsoft Excel for PC

3 Answers

Excel I am trying to create the following for my company and am stumped: Start Date * Rate of Starts per week(WORKDAY) = Finish Date I would like to change the rate of starts to give the finish date. Please help

Posted by on

3 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers
Re: Excel

Like previous poster, I'm guessing that you want something like this......Whate we need to know is : what formats do you need for Dates and Rate ?

Start Date Rate per Workday Finish Date

Posted on Jan 08, 2008

Re: Excel

  1. GFK'
  3. GDS',G

Posted on Jan 05, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.


    An expert that has over 500 points.

  • Expert
  • 272 Answers
Re: Excel

Your issue is not stated very clearly so I'll make some guesses about your problem.
I'm guessing you mean "rate" (Starts-per-Week) is the number of starts you have that week.
I'll guess that those starts are not new start dates but something else-maybe job starts.
Each start implies a job duration period. Do you want to know the finish date of each job or are you only interested in when the last job will be completed? Don't think I can give you meaningful Excel formulas at this time.
Maybe Excel is the best tool for this job but I suspect someting like Microsoft Project would be more appropriate (but expensive). You should Google "project tracking", "project orgainization" and "Gant chart" and read what you find to get a good feel for your problem and how to solve it.

Posted on Dec 29, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Workday function in excel formulas

The WorkDay Function returns a number that's the serial date that is the indicated number of working days from a given date (the starting date). Working days EXCLUDE weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.
The Syntax is:
- start_date is in Date format (and can be a calculated value);
- days is a number of elapsed days after start_date (can be calculated, can be negative to indicate a date BEFORE start_date);
- holidays is an array of holidays you can specify if desired.

May 01, 2014 | Microsoft Excel for PC

1 Answer

Reminder in excel

There are a couple of types of spreadsheet - Depending on the size of the data you are working with - filter may the quickest option or Query report.

Your worksheet will contain all your data i.e. Customer, contact no, outstaning actions and due date - You can create a filter aon this set criteria on the due data - as less than or equal to todays date - which will only display your outstanding actions required by today or earlier.

Another option if you have installed MS Query, is to create a seperate report - again using the criteria of due date being less than or equal to today.

Producing this from your existing data is much easier than trying to re-create your data - But I can send you how I would create this sheet if the above explanation is not easy to follow - If you let me have your email address.

May 31, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

REQUIRE EXCEL TIMESHEET Thursday to Wednesday. With DAY, date, start and end times with 1, 30 MIN meal break, total hours for the day (not to exceed 7), any time over 7 THEN GOES TO TIME IN LEIU COLLU

Here are already prepared template time sheets of which your description fits several.

May 30, 2009 | Microsoft Excel for PC

1 Answer


Yes you can create the formula outside the cell or you can create it one time and copy it down to the other cells. That way it will populate once it is used.

The formula should be Base Rate * .05 to get the result then add the result back to the base rate.

Dec 18, 2008 | Microsoft Excel for PC

1 Answer

Need to Add Dates in Excel

Here is one way I just tried:

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)
That will add 3 years.

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy

Nov 21, 2008 | Microsoft Excel for PC

3 Answers

Need excel solution

Hello ycool11, If your asking what i think you are the formula would be
That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

Oct 22, 2008 | Microsoft Excel for PC

1 Answer


cell 1 (date format) = start date
cell 2 (number format) = number of days = cell 3 - cell 1
cell 3 (date format) = deadline = cell 1 + cell 2

Oct 16, 2008 | Microsoft Excel for PC

1 Answer

Excel 2003

Put in the function TODAY and format the cell with Date = Wednesday, 25th April, 2008 (format)

Apr 25, 2008 | Microsoft Office 2003 Pro (269-07387) for...

1 Answer

Average handle time

I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

3 Answers

Microsoft worad and Excel document passoword recover

You can try the following URL..
hope to get rated as helpful

Dec 31, 2007 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Microsoft Excel for PC Logo

88 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides