b7659a |
DATE |
=DATE(2025, 3, 15) |
value |
|
422056 |
DATE |
=DATE(2024, 2, 29) |
value |
|
3844e3 |
DATE |
=DATE(2025, 13, 1) |
value |
1 |
867dc7 |
DATE |
=DATE(2025, 1, 32) |
value |
1 |
3082d8 |
DATE |
=DATE(2025, -1, 15) |
value |
1 |
1f9dec |
DATEDIF |
=DATEDIF("2020-01-15", "2025-03-20", "Y") |
value |
2 |
1562bb |
DATEDIF |
=DATEDIF("2020-01-15", "2025-03-20", "M") |
value |
2 |
1b8fd4 |
DATEDIF |
=DATEDIF("2025-01-01", "2025-02-01", "D") |
value |
2 |
a701fe |
DATEDIF |
=DATEDIF("2020-01-15", "2025-03-20", "MD") |
value |
2 |
6ab08d |
DATEDIF |
=DATEDIF("2020-01-15", "2025-03-20", "YM") |
value |
2 |
53e9f1 |
DATEVALUE |
=DATEVALUE("2025-03-15") |
value |
1 |
926286 |
DATEVALUE |
=DATEVALUE("March 15, 2025") |
value |
1 |
69df47 |
DATEVALUE |
=DATEVALUE("not a date") |
value |
|
129a60 |
DAY |
=DAY("2025-03-15") |
value |
1 |
c8e0eb |
DAY |
=DAY("2025-01-31") |
value |
1 |
d70217 |
DAY |
=DAY("2024-02-29") |
value |
1 |
c7a64b |
DAY |
=DAY(DATE(2025, 3, 15)) |
value |
|
85991c |
DAYS |
=DAYS("2025-03-15", "2025-03-01") |
value |
2 |
393422 |
DAYS |
=DAYS("2025-03-01", "2025-03-15") |
value |
2 |
f5d649 |
DAYS |
=DAYS("2025-03-15", "2025-03-15") |
value |
2 |
c7c68c |
DAYS |
=DAYS("2025-01-01", "2024-01-01") |
value |
2 |
a3d5e9 |
DAYS360 |
=DAYS360("2025-01-15", "2025-03-15") |
value |
2 |
ea35c8 |
DAYS360 |
=DAYS360("2024-01-01", "2025-01-01") |
value |
2 |
d5f0be |
DAYS360 |
=DAYS360("2025-01-31", "2025-03-31", TRUE) |
value |
2 |
93c302 |
EDATE |
=EDATE("2025-01-15", 3) |
value |
1 |
84511d |
EDATE |
=EDATE("2025-01-15", -3) |
value |
1 |
18d93a |
EDATE |
=EDATE("2025-01-31", 1) |
value |
1 |
e55076 |
EDATE |
=EDATE("2025-03-15", 0) |
value |
1 |
508d67 |
EOMONTH |
=EOMONTH("2025-03-15", 0) |
value |
1 |
dd8343 |
EOMONTH |
=EOMONTH("2025-03-15", 2) |
value |
1 |
04cfe3 |
EOMONTH |
=EOMONTH("2025-03-15", -1) |
value |
1 |
32629b |
EOMONTH |
=EOMONTH("2024-02-10", 0) |
value |
1 |
7c97b9 |
EPOCHTODATE |
=EPOCHTODATE(1700000000, 1) |
value |
2 |
57b878 |
EPOCHTODATE |
=EPOCHTODATE(1700000000000, 2) |
value |
2 |
788942 |
EPOCHTODATE |
=EPOCHTODATE(1700000000) |
value |
2 |
62c61f |
HOUR |
=HOUR("13:30:45") |
value |
1 |
64933c |
HOUR |
=HOUR("00:00:00") |
value |
1 |
fc9538 |
HOUR |
=HOUR(TIME(9, 15, 30)) |
value |
1 |
2bf6ea |
ISOWEEKNUM |
=ISOWEEKNUM("2025-06-15") |
value |
2 |
8b84e8 |
ISOWEEKNUM |
=ISOWEEKNUM("2023-01-01") |
value |
2 |
e16816 |
ISOWEEKNUM |
=ISOWEEKNUM("2024-01-01") |
value |
2 |
56627a |
MINUTE |
=MINUTE("13:30:45") |
value |
1 |
d7207e |
MINUTE |
=MINUTE("13:00:00") |
value |
1 |
c98d72 |
MINUTE |
=MINUTE(TIME(9, 15, 30)) |
value |
1 |
12fa4c |
MONTH |
=MONTH("2025-03-15") |
value |
1 |
577ba3 |
MONTH |
=MONTH("2025-12-31") |
value |
1 |
3fa813 |
MONTH |
=MONTH(DATE(2025, 7, 4)) |
value |
|
6f97b2 |
NETWORKDAYS |
=NETWORKDAYS("2025-03-03", "2025-03-07") |
value |
2 |
bb9294 |
NETWORKDAYS |
=NETWORKDAYS("2025-03-07", "2025-03-10") |
value |
2 |
27c866 |
NETWORKDAYS |
=NETWORKDAYS("2025-03-03", "2025-03-07", "2025-03-05") |
value |
2 |
10c040 |
NETWORKDAYS |
=NETWORKDAYS("2025-03-07", "2025-03-03") |
value |
2 |
9f3714 |
NETWORKDAYS.INTL |
=NETWORKDAYS.INTL("2025-03-03", "2025-03-07", 1) |
value |
2 |
f72cc6 |
NETWORKDAYS.INTL |
=NETWORKDAYS.INTL("2025-03-03", "2025-03-09", 11) |
value |
2 |
340cf7 |
NETWORKDAYS.INTL |
=NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000011") |
value |
2 |
094014 |
NETWORKDAYS.INTL |
=NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000001") |
value |
2 |
73b857 |
NOW |
=NOW() |
volatile |
|
a18a6a |
SECOND |
=SECOND("13:30:45") |
value |
1 |
a99bfd |
SECOND |
=SECOND("13:30:00") |
value |
1 |
494718 |
SECOND |
=SECOND(TIME(9, 15, 30)) |
value |
1 |
9eff02 |
TIME |
=TIME(9, 30, 0) |
value |
|
21d254 |
TIME |
=TIME(0, 0, 0) |
value |
1 |
bcf008 |
TIME |
=TIME(25, 0, 0) |
value |
|
c77c9c |
TIMEVALUE |
=TIMEVALUE("13:30:00") |
value |
|
bc3a00 |
TIMEVALUE |
=TIMEVALUE("12:00:00") |
value |
|
8daf14 |
TIMEVALUE |
=TIMEVALUE("00:00:00") |
value |
|
9d3277 |
TODAY |
=TODAY() |
volatile |
|
74abbd |
WEEKDAY |
=WEEKDAY("2025-03-16") |
value |
1 |
3857f9 |
WEEKDAY |
=WEEKDAY("2025-03-17", 1) |
value |
1 |
db3d66 |
WEEKDAY |
=WEEKDAY("2025-03-17", 2) |
value |
1 |
bf55ff |
WEEKDAY |
=WEEKDAY("2025-03-17", 3) |
value |
1 |
98f2b9 |
WEEKNUM |
=WEEKNUM("2025-01-05") |
value |
2 |
881477 |
WEEKNUM |
=WEEKNUM("2025-01-05", 2) |
value |
2 |
1554f7 |
WEEKNUM |
=WEEKNUM("2023-01-01", 21) |
value |
|
81d5c5 |
WORKDAY |
=WORKDAY("2025-03-03", 5) |
value |
2 |
2c2fe9 |
WORKDAY |
=WORKDAY("2025-03-10", -5) |
value |
2 |
f474a4 |
WORKDAY |
=WORKDAY("2025-03-03", 5, "2025-03-05") |
value |
2 |
79d179 |
WORKDAY |
=WORKDAY("2025-03-03", 0) |
value |
2 |
60ae88 |
WORKDAY.INTL |
=WORKDAY.INTL("2025-03-03", 5, 1) |
value |
2 |
046128 |
WORKDAY.INTL |
=WORKDAY.INTL("2025-03-03", 5, 7) |
value |
2 |
13319d |
WORKDAY.INTL |
=WORKDAY.INTL("2025-03-03", 5, "0000011") |
value |
2 |
2fa3fa |
WORKDAY.INTL |
=WORKDAY.INTL("2025-03-03", 5, "0000001") |
value |
2 |
7c28b7 |
YEAR |
=YEAR("2025-03-15") |
value |
1 |
dcec46 |
YEAR |
=YEAR(DATE(1999, 12, 31)) |
value |
|
f17d55 |
YEAR |
=YEAR("2000-01-01") |
value |
1 |
83857b |
YEARFRAC |
=YEARFRAC("2025-01-01", "2025-07-01") |
value |
1 |
7c7488 |
YEARFRAC |
=YEARFRAC("2025-01-01", "2026-01-01", 0) |
value |
1 |
1045d9 |
YEARFRAC |
=YEARFRAC("2025-01-01", "2026-01-01", 1) |
value |
1 |
daf9af |
YEARFRAC |
=YEARFRAC("2025-01-01", "2026-01-01", 2) |
value |
|
69069f |
YEARFRAC |
=YEARFRAC("2025-03-15", "2025-03-15") |
value |
1 |