Create Calculation to return number of weeks and days
That did it!!!!! Thank you soooooo much!!!!!!
"Mike H" wrote:
Try
=INT(DATEDIF(A2,B2,"d")/7) & " Weeks "&MOD(DATEDIF(A2,B2,"d"),7)&" Days"
Mike
"Lisa D" wrote:
I need to create a formula where it calculates the number of weeks and days
between 2 dates.
For example:
A2 = 12/25/08
B2 = 1/30/09
C2 = 5 weeks 1 day
I found example formulas that calculates years, months and days....but no
weeks.
Any help is most appreciated!
Thanks!
|