writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 54:
Line 54: + + + + + + + − + + − + + − + + − + + − + + Line 85:
Line 97: − + − +
→Examples
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" |
| class="sshl_f" | A
| class="sshl_f" | B
| class="sshl_f" | C
|- class="odd"
| class="sshl_f" | 1
| class=" " | September 10, 2010
| class=" " | September 10, 2010
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="even"
| class="sshl_f" | 2
| class="sshl_f" | September 10, 2016
| class="sshl_f" | September 10, 2016
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
|- class="odd"
| class="sshl_f" | 3
| class=" " | 6%
| class=" " | 6%
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="even"
| class="sshl_f" | 4
| class=" " | 9.0%
| class=" " | 9.0%
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
|- class="odd"
| class="sshl_f" | 5
| class=" " | 2
| class=" " | 2
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="even"
| class="sshl_f" | 6
| class=" " | 1
| class=" " | 1
| class=" " |
| class=" " |
|}
|}
=DURATION(A1,A2,A3,A4,A5,A6) ''displays 5.045790027952841'' as a result.
=DURATION(A1,A2,A3,A4,A5,A6) displays '''5.045790027952841''' as a result.
=DURATION(DATE(2013,6,1),DATE(2013,12,31),"6%","8%",1,1) ''displays 1.9423897589712318'' as a result.
=DURATION(DATE(2013,6,1),DATE(2013,12,31),"6%","8%",1,1) displays '''1.9423897589712318'' as a result.
==Related Videos==
==Related Videos==