You are saying you want to add 1 to the result of the B2-A2 subtraction. Do
you need someone to tell you how to add 1 to B2-A2?
--
David Biddulph

"tsony" wrote in message
...
Dear David,

If we include the end date what formula we use for eg 01/01/08 to 21/01/08
number of days should be 21. if we deduct the two dates the result comes
to
20, please advice

"David Biddulph" wrote:

=INT((B2-A2)/7)&" weeks and "&MOD(B2-A2,7)&" days"
--
David Biddulph

"tsony" wrote in message
...
Is anybody knows how to deduct two dates and the result should be in
number
of weeks and days (eg. 26 days should be 3 weeks and 5 days)?