Women in Technology

Hear us Roar

  Using Excel's Calendar Controls
Subject:   Subtracting time periods.
Date:   2006-05-15 12:17:25
From:   Biter
I have used the formula =TRUNC(((X7)-W7)/7)&"Wks&"&MOD(X7-W7,7)&"Days" to calculate the time period between two dates in the following format, 6Weeks&4Days. I now wish to compare different periods, calculated in the way above, to find the difference between them, i.e. I want to be able to subtract say, 4Weeks&5Days from 6Weeks&4Days and get the result 1Weeks&6Days.

Any help would be much appreciated.