These are new functions introduced in Excel 2013. Here the SHEET() function is used to determine the current sheet on which we are currently working and returns the result as the number that indicates the current sheet. The Sheets() function is used to return the total number of sheets present in the workbook in Excel 2013.
Let's have a look at the following steps.
Step 1
First go to Excel 2013.
Step 2
Now select the blank workbook template from the available templates.
Step 3
Now take some sheets in our Excel sheet by clicking on the + sign as shown below and give them weekday names like this:
Step 4
Now write the following formula to determine the current Sheet on which we are working.
Step 5
The output will be like this:
Here 2 indicates the second sheet is the current sheet on which we are working.
Step 6
Now write the following formula to determine what is the number of the sheet named "thu" containing the A1 cell.
Step 7
The output will be like this:
Here 4 indicates that the fourth sheet name is "thu" containing cell A1.
Step 8
Now write the following formula to determine the total number of worksheets present in the current workbook:
Step 9
The output will be like this: