How to calculate no of days between two dates in Ms.Excel ?. I need to calculate days for markup calculations between entries so that i must get exact markup calculated please.

Do you need it exclude Weekends & Holidays?

Then use the NETWORKDAYS() function which looks like:=NETWORKDAYS(start_date,end_date,[holidays range])

So with your Start Date in A1, your End Date in B1

and you list of Holidays is the range C1 thru C10

it would look like:=NETWORKDAYS(A1,B1,C1:C10)

If you do not need to exclude Weekends or Holidays

then you could use the DATEDIF() function:=DATEDIF(start_date,end_date,unit)

The units are "D" Day, "M" Month, ""Y" Year and several others.

=DATEDIF(A1,B1,"D")

or you can do a simple subtraction:

=B1 - A1

Take your pick.MIKE

Ask Your Question

Weekly Poll