There are two different levels of hidden sheets within Excel, hidden and the less well-known very hidden worksheets. We can easily hide our worksheets by right-clicking the sheet tab and selecting hide. There’s a more extreme option available. Very Hidden means the sheet/tab doesn’t show up at all in regular Excel and ensures the sheet […]
The Excel function EOMONTH() returns the date of last day in a month. With a little extra, it’ll tell you the number of days in any month. EOMONTH() is the Excel equivalent of the little rhyme ‘30 Days has September, April, June and November …’ plus it handles leap years with 29th February. Applies To Excel for […]
Here’s a step-by-step example of Networkdays.Intl() in an Excel worksheet. We suggest using that improved function over the older NetworkDays() with less options. As usual, you can select the formulas tab and Excel will guide you through the process. From Formulas | Date & Time choose NETWORKDAYS.INTL . It will open a dialog box to […]
The NETWORKDAYS function in Microsoft Excel will calculate the number of working days between two dates. It will automatically exclude weekends (e.g. Saturday and Sunday) plus you can exclude public holidays and personal vacations. Most people read the function as ‘Network Days’ but it’s really ‘Net Work Days’. Figure out employee benefits from total working […]
