Zaigham
Board Regular
- Joined
- Dec 22, 2010
- Messages
- 144
Excel Workbook | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | From | To | Year | Month | Days | ||
2 | 01.05.1984 | 18.07.1985 | 1 | 14 | 18 | ||
3 | 03.06.1989 | 27.06.1989 | 0 | 0 | 25 | ||
4 | 15.02.1991 | 05.03.1991 | 0 | 0 | 19 | ||
5 | Total Period ==>> | * | 1 | 14 | 62 | ||
6 | Result Required | * | 2 | 4 | 2 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C6 | =C5+INT(D5/12) | |
D6 | =MOD(D5,12)+INT(E5/30) | |
E6 | =MOD(E5,30) |
ADVERTISEMENT
......so total period comes to 2 years 4 months and 2 days......
ADVERTISEMENT
Excel Workbook | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Y | M | D | ||
2 | 18 | 0 | 25 | ||
3 | 1 | 4 | 2 | ||
4 | 16 | 8 | 23 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A4 | =IF(A2>A3,A2-A3,A2+12-A3)-(B3>B2) | |
B4 | =IF(B2>B3,B2-B3,B2+12-B3)-(C3>C2) | |
C4 | =IF(C2>C3,C2-C3,C2+30-C3) |