At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
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
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
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.
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.
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.
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.
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.
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 1 + 1: =1+1
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.
×