Excel question - is there a formula that can automatically update based on the day of the week? - sample save the date birthday
http://i30.photobucket.com/albums/c326/Jennifer__B/SampleExcelWorksheet.jpg
Above link to view a sample sheet mockery. To fill the column I am looking for AJ5 - AJ26. I've got it as close as possible to keep that size, because this is not my document for change. Thus, on information from the sample, 13 to, I want AJ totals column 1 to 12 days. On 14 I would be the sum of columns 1 to 14 as AJ, etc. Is there a formula for what will be updated automatically without having to manually change the formula every day? A solution to this problem would save my day!
If it helps, I have upgraded to a cell in the document automatically, the current date. However, I wonder if trying to be a bond at the time on the wrong track?
Monday, January 25, 2010
Sample Save The Date Birthday Excel Question - Is There A Formula That Can Automatically Update Based On The Day Of The Week?
Subscribe to:
Post Comments (Atom)
1 comments:
Well I tried this function with a table, but I could not because one of the columns total at the end of each week.
= SUM (IF (C $ 4: AE $ 4 \\ \\ \\ \\ \\ \\ \\ \\ u0026lt, DAY (TODAY ()), C5: AE5, 0 ...
So I tried to delete the entire column and uses a function, but not about the ability of Excel to use the matrix functions may seem. The best I could achieve is a hidden row below each line to create and use this formula.
U0026lt = IF (C $ 4 \\ \\ \\ \\ \\ \\ \\ \\; = DAY (TODAY ()), C5, 0)
In cell C5, then c'n'p the cells C5: "E4". You must delete add the formula in each column that you do not want, namely, the "Total" columns.
At the time "to" column in row 5, insert the formula.
= SUM (C6: AE6)
It is assuming too much work, you do not have many analysts. Here are the instructions to do step by step, as soon as possible, because the former is not entirely clear.
1. Select the row 6, right-click and select Insert Row.
2. Cut and paste this formula in cell C5
U0026lt = IF (AND (C $ 4 \\ \\ \\ \\ \\ \\ \\ \\; = DAY (TODAY ()), NO (ISBLANK (...
3. We copy the cell C5, select cells C6: AE6, select Paste Special and select the form, then click OK.
4. AJ5 Select the cell. Enter this formula.
= SUM (C6: AE6)
5. Select the line 5 and again select "Copy".
6. Start with the last line and select Paste copied cells. This causes a bit tedious as the number of analysts who have to do. Repeat step 5 until you insert lines for each analyst.
7. Select the cells AJ5: AJ6. With the right mouse button and select Copy.
8. Select all rows with analysts and the newly inserted rows.
9. With the right mouse button and select "Paste" and then select the formula and then click OK.
10. Select the newly inserted rows by using the button at the top and left side of the mouse. Click on a number of the line, and select Hide.
Hell, even if it seems confusing. Here is a short video will show you what I hope that in the case of the above instructions were confusing. It is a little over 5 MB in size. Hopand has a fast Internet connection. This special file-hosting site is much traffic, so you can see a few attempts to download. : P
http://www.sendspace.com/file/6dfhnj
I must say that I have a new respect for the teachers video. It took about 20 takes to get it right the video. :)
Post a Comment