NETWORKDAYS – Excel for Engineers

Working With Dates in Excel

ByRick November 11, 2022December 6, 2022

Microsoft Excel stores dates as sequential serial numbers for use in calculations. 1 January 1900 is serial number 1. 2 January 1900 is serial number 2, and so on. Thus, 1 January 2000 is serial number 36526 because it is 36,525 days after 1 January 1900. This means that you can do maths with dates. …

Excel Functions

Get Work Days with NETWORKDAYS and WORKDAY

ByRick October 19, 2022October 28, 2022

Do you need to find out how many working days –excluding weekends and holidays– there are in a given period? Or find out on what date a given number of work days will end? You need NETWORKDAYS and WORKDAY. The NETWORKDAYS function in Microsoft Excel returns the number of whole working days inclusive from a…