Difference between revisions of "Microsoft Excel Tips and Tricks"
From Free Knowledge Base- The DUCK Project: information for everyone
m |
m |
||
| Line 1: | Line 1: | ||
| − | === Refer to cell in another worksheet == | + | === Refer to cell in another worksheet === |
Reference the worksheet name like this: sheet1!C12 | Reference the worksheet name like this: sheet1!C12 | ||
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))
