![]() You can now copy the formula down as far as you want and it will show only the upcoming workdays. To understand how it works watch the WORKDAY video clip This formula assumes that Saturday and Sunday are non work days and also assumes that the public holidays listed in C2 to C15 are non work days. The formula above will start at and will show you the date of the next workday. Now in Cell A3 type the following formulae In cell C2 to C15 list the public holidays you want to take into account. Open a new workbook and in cell A2 enter the start date e.g. Using this function means you that you won’t need to enter every date and it can even take into account public holidays. If you are looking to create an Excel logbook for SARS and you want it to include the dates for working days only, you can easily create it in Excel using the WORKDAY function. Free Excel logbook for SARS download at the bottom of the page
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |