||Using Excel's Calendar Controls|
|Subject:||Subtracting time periods.|
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.