Question about Microsoft Excel for PC

3 Answers

Formulas in microsoft excel 2007 - Microsoft Excel for PC

Posted by on

  • kwilshusen Nov 12, 2008

    I am trying to get excel to recognize that a certain date range.. such as 12/29/08 - 1/4/09 would be equal to week 1 in the year. (and so on)

  • Eeeeeeeeeekz May 11, 2010

    what specific formulas are you looking for?

×

3 Answers

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 45 Answers

None. just imagine if the dates is seven days apart but cut accross two weeks.

Posted on Nov 17, 2008

  • Danilo Mante
    Danilo Mante Nov 17, 2008

    excel can count the number of days (to make a week) but the date range may belong to at least 2 weeks of a year.

×

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Scholar:

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

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 120 Answers

Hello kwilshusen, If you pull up excel and type in the format 8/12/2008 it will read mm/dd/yyyy, you should be able to right click and format cells to your liking.
I hope that was what you were looking for, if not post again and i'll try to help.
Thanks and i look forward to your post.

Posted on Nov 12, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

    Novelist:

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

  • Expert
  • 185 Answers

Excel 2007 has a rather elaborate formula pull down menu.it out,

Loringh

Posted on Nov 12, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

What is the function of Microsoft excel?


Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

Formula


check this link it will help you to learn excel

http://people.usd.edu/~bwjames/tut/excel/

dont forget to rate ^^

Jun 08, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Excel Formula


With data in A1 to C1: A2 =IF(A1>0,1,0) B2 =IF(B1>0,1,0) C2 =IF(C1>0,1,0) A3 =SUM(A2:C2)

Jun 04, 2009 | Microsoft Office Excel 2007

1 Answer

Rounding Time in Excel 2007


format the cells that contains times and net time worked as time format you using Enter the simple formula   =if(c14<=0,Int(0),(c14-c13))

Feb 04, 2009 | Microsoft Excel for PC

1 Answer

Countifs


The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.
=countif(A1:B9,1)

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Excel


Step1. Start Microsoft Excelmag-glass_10x10.gif and open the file you want to change. Step2. Double-click on the cell where you want the total to appear. Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell. Step4. Enter the formula, then press Enter. Follow the steps below for an example. Step5. Enter an opening parenthesis character: (. Step6. Enter a cell name. For example: =(E2. Step7. Press the + key. Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell. $('.Article .Steps .Image').each(function(i,e){ e = $(e); e.find('img').error(function(){ $(this).unbind(); e.remove(); }); });
Tips & Warnings
  • Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
  • Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")
I hope it helps!!!

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Microsoft office 2007 excel problem when i save excel files then i coulnd not save a file , because there some tmp error


Hi,
Just re-install the excel only using your ms office 2007. Once you put the installer on the drive it will give an option on what office you want to install, just select excel.
Thanks

Nov 25, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Formula for calculating the days beween months


for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

1 Answer

WRITING A LONG IF AND THEN FORMULA


The OS should not impact on the performance of Excel..
Have you upgraded excel from 2000 to 2007 ??

Power formulas are tricky to manage at the best of times.
The formulas that you have wrote for years may have been on the knife edge ... i.e. just less than 256 characters.
Have you exceeded this limit ??

Aug 06, 2008 | Microsoft Excel for PC

4 Answers

How many formulas we can use at a time in Excel


That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

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

Related Topics:

102 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

Les Dickinson
Les Dickinson

Level 3 Expert

18297 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

Loading...