days between dates

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

Bill H.

What is the formula to use to I calculate the number of days between dates
in two cells?

thx.
 
=B1-A1 and format the cell as General otherwise it will show a meaningless
date
best wishes
 
What is the formula to use to I calculate the number of days between dates
in two cells?

thx.
Click to expand...

if A1 had the older date date and B1 had the new date then
=DATEDIF(A1,B1,"d")
 
What is the formula to use to I calculate the number of days between dates
in two cells?

thx.
Click to expand...

if A1 had the older date date and B1 had the new date then
=DATEDIF(A1,B1,"d")

Excel- days difference between dates


This is perennial trap. The answer lies in if you are counting gross or net
days.



In a simple example, if a person starts work on 1 January and ends work on 2
January, 2 days pay would be due. Calculating the number of days pay by
taking the last day less the first day would result in an underpayment by
one day. It is, therefore, important when calculating gross days to add one
day (i.e. =date2-date1+1)


Bill Ridgeway
 
Back
Top