The function datedif()

has the format
=datedif(date1,date2,"d") for number of days between the two dates
or
=datedif(date1,date2,"m") for number of complete months between the two dates
or
=datedif(date1,date2,"y") for number of complete years between the two dates
it even allows other combinations - but not complete weeks.

please note that date1 has to be less than date2 for this funtion to work.

I agree that there are other ways to "get" the answer, but if the function
is there - having a "week" selection doesn't seem unreasonable.



"Bob I" wrote:

Umm, there is no week in a Date.

Brad wrote:

Currently day, month, year and combinations of these can be used with this
function. Please add week to this function.