Date Functions In AFC
The supported date functions are shown by example below:
| A | B | C | D | E |
6 | 39447.0 | =DATE(C6,D6,E6) | 2007.0 | 12.0 | 31.0 | |
7 | 22383.0 | ... | 1961.0 | 4.0 | 12.0 | |
8 | 2713.0 | ... | 7.0 | 6.0 | 5.0 | |
9 | 38356.0 | ... | 2003.0 | 23.0 | 65.0 | |
10 | 39040.0 | ... | 2008.0 | -10.0 | -73.0 | |
| A | B | C | D | E |
12 | 0.08546296296296296 | =TIME(C12,D12,E12) | 2.0 | 3.0 | 4.0 | |
13 | 0.7055439814814815 | ... | 16.0 | 55.0 | 59.0 | |
14 | 0.6800462962962961 | ... | 39.0 | 78.0 | 76.0 | |
15 | 0.9814814814814814 | ... | 100.0 | -200.0 | -4000.0 | |
| A | B | C |
17 | 45.0 | =SECOND(C17) | 0.5213541666666667 | |
18 | 0.0 | ... | 35222.5 | |
19 | 59.0 | ... | 3653.999988425926 | |
20 | 59.0 | ... | 3653.999994 (#0.000000) | |
21 | 0.0 | ... | 3653.999995 (#0.000000) | |
| A | B | C |
23 | 30.0 | =MINUTE(C23) | 0.5213541666666667 | |
24 | 0.0 | ... | 35222.5 | |
25 | 59.0 | ... | 3653.999988425926 | |
26 | 59.0 | ... | 3653.999994 (#0.000000) | |
27 | 0.0 | ... | 3653.999995 (#0.000000) | |
| A | B | C |
29 | 12.0 | =HOUR(C29) | 0.5213541666666667 | |
30 | 12.0 | ... | 35222.5 | |
31 | 23.0 | ... | 3653.999988425926 | |
32 | 23.0 | ... | 3653.999994 (#0.000000) | |
33 | 0.0 | ... | 3653.999995 (#0.000000) | |
| A | B | C | D |
35 | 7.0 | =WEEKDAY(C35) | 39452.0 | |
36 | 1.0 | ... | 39453.0 | |
37 | 7.0 | =WEEKDAY(C37,D37) | 39452.0 | 1.0 | |
38 | 1.0 | ... | 39453.0 | 1.0 | |
39 | 7.0 | ... | 39453.0 | 2.0 | |
40 | 1.0 | ... | 39454.0 | 2.0 | |
41 | 6.0 | ... | 39453.0 | 3.0 | |
42 | 0.0 | ... | 39454.0 | 3.0 | |
43 | 0.0 | ... | 39454.0 | 3.0 | |
44 | !FE | ... | 39454.0 | 4.0 | | Excel says: #NUM! |
| A | B | C |
46 | 1.0 | =DAY(C46) | 40179.0 | |
47 | 6.0 | ... | 35222.5 | |
48 | 31.0 | ... | 3653.0 | |
| A | B | C |
50 | 1.0 | =MONTH(C50) | 40179.0 | |
51 | 6.0 | ... | 35222.5 | |
52 | 12.0 | ... | 3653.0 | |
| A | B | C |
54 | 2010.0 | =YEAR(C54) | 40179.0 | |
55 | 1996.0 | ... | 35222.5 | |
56 | 1909.0 | ... | 3653.0 | |
| A | B | C | D | E |
58 | 1095.0 | =DAYS360(C58,D58) | 35222.0 | 36332.0 | |
59 | 3600.0 | ... | 7305.999363425926 | 10958.561805555555 | |
60 | -331.0 | =DAYS360(C60,D60) | 39788.0 | 39452.0 | |
61 | 331.0 | =DAYS360(C61,D61) | 39452.0 | 39788.0 | |
62 | 180.0 | ... | 34758.0 | 34942.0 | |
63 | 180.0 | ... | 35124.0 | 35308.0 | |
64 | 60.0 | ... | 35094.0 | 35155.0 | |
65 | 60.0 | ... | 35095.0 | 35155.0 | |
64 | 60.0 | ... | 35094.0 | 35155.0 | |
67 | 182.0 | =DAYS360(C67,D67,E67) | 34758.0 | 34942.0 | true | |
68 | 180.0 | ... | 34758.0 | 34942.0 | false | |
69 | 181.0 | ... | 35124.0 | 35308.0 | true | |
68 | 180.0 | ... | 34758.0 | 34942.0 | false | |