Question about Microsoft Office Professional 2007 Full Version for PC

# Question is about Microsoft EXCEL FORMULA 1) Column A has 1,2,3,4 ?.. up to 31 starting from A1numbers 2) Column B1 has weekday code. Starting number may be any number between 1 to7. Suppose B1 is 5, B2 is 6, B3 is 7, B4 is 1, B5 is 2 and on. 3) In Column C it should copy column A1, A2?up to A31, starting from matching number of column A & B (First no of column B1 is 5 and fifth no of row column A is 5. In this case starting of C5 will be value of A1, ( C1 to C4 will be blank) C6 will be value of A2, C7 will be value of A3 and so on. What formula to be written in cells of column C ? In column A dates are written, column B weekday codes 1 to 7 are written

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

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.

• Expert

Try this:

=LOOKUP(B4,A\$1:A\$31,A\$1:A\$31)

Posted on Sep 06, 2009

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a...

This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for \$15, which I'm sure you now realize after 10 days of trying.

Thanks
Tim

Sep 26, 2010 | Microsoft Excel for PC

### Excel formula related to a date range

Use the IF and Date functions together. On sheet 3, put the birthday (3/15/1954) in cell B1, put the beginning date (1/1/1946) in cell C1 and the ending date (12/31/1964) in cell D1.
Then on Sheet 1, but the following formula in the cell you want an X to be placed in.
=IF(AND(Sheet3!B1>=Sheet3!C1,(Sheet3!B1<=Sheet3!D1)),"X"," ").
Make sure you type the formula Exactly as it appears.

Mar 20, 2009 | Oracle Database Enterprise Named User Plus

### How to add % (Percentage column ) in the excel

The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:
=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Computers & Internet

Here is one way to do it:
1. In column A enter the name
2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)
3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)
4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)
5. In column E, put this formula:
(D2/30)*1.25 (assuming this is line 2)
You can then copy these lines as many times as you need to, total them, etc.

Dec 27, 2008 | Microsoft Office Standard for PC

### DATE DIFERANCE BETWEEN SELECTED COLOUMN

Are you trying to figure the difference in days between these dates and one single date (Dec. 31, 2008 for example)?

Whatever you're trying to do, here is the formula, assuming you're starting in A1:
Put the first date in the format Day-Month-Year in numbers (Sept. 3 is 03-09-2008)
Then put your other date in B1, in Day-Mo-Yr format (31-12-2008 for Dec. 31, 2008)
In C1 put B1-A1 and that will give you the number of days between those two dates.

Dec 27, 2008 | Microsoft Excel for PC

### Formula for Calculating the turn around time in excel

dpprash,

I guess you mean the number of weekdays (or working days) excluding Saturdays and Sundays. So start a spreadshhet and put the start date (01/01/2009) in A2 and the end date (31/12/2009?) in B2.

Then paste the formula below into C2:

=B2-A2-2*INT((B2-A2+WEEKDAY(A2,3))/7)-MAX(0,WEEKDAY(B2,3)-4

better-swiss

Dec 18, 2008 | Microsoft Excel for PC

### Excel will not displaying the results of a trend array formula

Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

### BASIC EXCEL FORMULA

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

columns: A B C D
rows
1 20 3
2 10 4
3 15 2
4 1 2 3

Then suppose you type in the following formulas (in the D column):

columns: A B C D
rows
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

columns: A B C D
rows
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

Sep 29, 2008 | Microsoft Computers & Internet

### Computer

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Computers & Internet

## Open Questions:

#### Related Topics:

87 people viewed this question

Level 3 Expert

Level 3 Expert