And correction on the interpretation of the formula
[Users questions | Browse:80 | Favorites]
Users questions: =IF(COLUMN(G1) =DAY(EOMONTH($D$2,0)),DAY(DATE(YEAR($D$2),MONTH($D$2),COLUMN(G1))), )=IF(COLUMN(G1) = DAY (EOMONTH ($ D $ 2,0)), WEEKDAY (DATE (YEAR ($ D $ 2), MONTH ($ D $ 2), J3), 1 ),"")
Experts answer: For example, cell D2 7, 2008 months, then a formula where the first Cell returns a value of 7 (that is, the G1's out), if in the table to the right drag this formula, the return value followed by columns 8,9,10 AE pulled back until 31, then pull it right return value is empty. Of course, if the cell D2 for 6 months, then the return value is empty after 30. Article Two formulas, assuming that D2 is still in July 2008, J3 value of 3, then the formula returns a value of 3 July 2008 is the day of the week, (but this week the week with a few Chinese people use the same format, It started a week from Sunday, so it returns the week of July 3, No. 1 value, but with Way to remember a week in China, should return 2, if you want to return 2 WEEKDAY brackets put a comma after the last 1 to 2 this formula and the previous one, right after the last day of the month to pull it right to pull empty. Calendar you are doing it.
Experts answer: For example, cell D2 7, 2008 months, then a formula where the first Cell returns a value of 7 (that is, the G1's out), if in the table to the right drag this formula, the return value followed by columns 8,9,10 AE pulled back until 31, then pull it right return value is empty. Of course, if the cell D2 for 6 months, then the return value is empty after 30. Article Two formulas, assuming that D2 is still in July 2008, J3 value of 3, then the formula returns a value of 3 July 2008 is the day of the week, (but this week the week with a few Chinese people use the same format, It started a week from Sunday, so it returns the week of July 3, No. 1 value, but with Way to remember a week in China, should return 2, if you want to return 2 WEEKDAY brackets put a comma after the last 1 to 2 this formula and the previous one, right after the last day of the month to pull it right to pull empty. Calendar you are doing it.
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.