Days between two dates, add working days, find month end, and the reason your date turned into a five-digit number.
Free, no signup, nothing to download. Results update as you type.
=B2-A2That gives the number of days between two dates. Format the result cell as a Number, not a Date, or it shows a date in 1900 instead of a count.
A date is stored as a number of days since 1900, which is why subtracting two dates gives a plain count and why a difference formatted as a Date shows something absurd. NETWORKDAYS counts working days inclusive of both ends; WORKDAY moves forward by working days; EOMONTH jumps to a month end.
Because that is what a date actually is. Excel stores dates as days since 1900, so 45000 is a real date wearing the wrong format. Set the cell format to Date and it comes back, with nothing lost.
Plain subtraction counts the gap, not the days involved. From Monday to Friday is 4 by subtraction and 5 working days by NETWORKDAYS, which counts both endpoints. Decide which one your business means before reporting it.
Put them in a column and pass that range as the last argument to NETWORKDAYS or WORKDAY. Lock it with dollar signs so it does not drift when the formula fills down.
The same numbers, live off the rows your team already edits, in a spreadsheet that rolls them up for you. Start your 7-day free trial, no credit card required.