Difference between revisions of "Microsoft Excel Tips and Tricks"
From Free Knowledge Base- The DUCK Project: information for everyone
(New page: Category:Computer_Technology Category:Microsoft Category:Desktop Software Category:Software) |
m |
||
| Line 1: | Line 1: | ||
| + | === Refer to cell in another worksheet == | ||
| + | Reference the worksheet name like this: sheet1!C12 | ||
| + | |||
| + | In the example there is a worksheet for each month of the year. To reference a value in cell E7 from the January worksheet in the February worksheet do this: | ||
| + | |||
| + | =January!E7 | ||
| + | |||
| + | === Increment month by one === | ||
| + | |||
| + | Easy way but not always accurate, just add the number of days to next month: | ||
| + | =DATE(2009,1,15)+31 | ||
| + | |||
| + | Use EDATE from Analysis Toolpak (Tools>Add-ins and check Analysis Toolpak) | ||
| + | =EDATE(A1,1) | ||
| + | |||
| + | With the Date function | ||
| + | =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) | ||
| + | |||
| + | | ||
| + | |||
| + | | ||
[[Category:Computer_Technology]] | [[Category:Computer_Technology]] | ||
Revision as of 12:46, 26 January 2009
= Refer to cell in another worksheet
Reference the worksheet name like this: sheet1!C12
In the example there is a worksheet for each month of the year. To reference a value in cell E7 from the January worksheet in the February worksheet do this:
=January!E7
Increment month by one
Easy way but not always accurate, just add the number of days to next month:
=DATE(2009,1,15)+31
Use EDATE from Analysis Toolpak (Tools>Add-ins and check Analysis Toolpak)
=EDATE(A1,1)
With the Date function
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
