Solved How to calculate no of days between two dates in Ms.Excel ?.

December 24, 2014 at 04:00:41
Specs: Windows XP
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.



See More: How to calculate no of days between two dates in Ms.Excel ?.

Report •


#1
December 24, 2014 at 07:38:47
✔ Best Answer
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

http://www.skeptic.com/


Report •
Related Solutions


Ask Question