Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.
You can see an example below, were we build the date using Excel’s date function and substract the values.
SpreadsheetConverter cannot handle dates in dropdown lists.
Instead use DATE to build a date. See
Use 24 hour clock, or if 12 hour clock is very important, use 2 fields one for 0-11 and a dropdown list for AM/PM and use TIME().
Or you can use TIME to build time values, for an example see
To output date, use date formats, for example ‘hh:mm’
We use the same format for dates as in regional settings. However, there might be issues. In the worst case, you might to have to change your input method and to like this:
Please verify that you’re not using Apple Macintosh dates which start 1904. Normal Excel dates start 1900.
Click on Download to install and test this Excel add-in for Windows.
Click on Upload to let us convert a spreadsheet for you for free.