Excel functions · 25 functions
Excel date and time functions
Functions that build dates, split them into parts, count the days, months or workdays between two dates and find due dates: DATE, EDATE, DATEDIF, NETWORKDAYS, WORKDAY.
Functions explained in full
- DATEBuilds a date from year, month and day.
- DATEDIFDifference between dates ("Y", "M", "D", "YM", "MD", "YD").
- DAYDay of the month (1–31).
- DAYSDays between two dates.
- EDATEDate a number of months before or after.
- EOMONTHLast day of the month, months away.
- MONTHMonth of a date (1–12).
- NETWORKDAYSWorking days between two dates.
- NOWCurrent date and time.
- TODAYToday's date.
- WEEKDAYDay of the week (1 = Sunday; type 2 makes Monday 1).
- WEEKNUMWeek number of the year.
- WORKDAYDate a number of working days away.
- YEARYear of a date.
- YEARFRACFraction of a year between two dates.
All functions
Builds a date from year, month and day.
=DATE(year, month, day)Difference between dates ("Y", "M", "D", "YM", "MD", "YD").
=DATEDIF(start_date, end_date, unit)Day of the month (1–31).
=DAY(serial_number)Days between two dates.
=DAYS(end_date, start_date)Date a number of months before or after.
=EDATE(start_date, months)Last day of the month, months away.
=EOMONTH(start_date, months)Month of a date (1–12).
=MONTH(serial_number)Working days between two dates.
=NETWORKDAYS(start_date, end_date, [holidays])Current date and time.
=NOW()Today's date.
=TODAY()Day of the week (1 = Sunday; type 2 makes Monday 1).
=WEEKDAY(serial_number, [return_type])Week number of the year.
=WEEKNUM(serial_number, [return_type])Date a number of working days away.
=WORKDAY(start_date, days, [holidays])Year of a date.
=YEAR(serial_number)Fraction of a year between two dates.
=YEARFRAC(start_date, end_date, [basis])- DATEVALUETARİHSAYISI
Converts a date written as text to a date.
=DATEVALUE(date_text) - DAYS360GÜN360
Days between dates on a 360-day year.
=DAYS360(start_date, end_date, [method]) - HOURSAAT
Hour (0–23).
=HOUR(serial_number) - ISOWEEKNUMISOHAFTASAY
ISO week number.
=ISOWEEKNUM(date) - MINUTEDAKİKA
Minute (0–59).
=MINUTE(serial_number) - NETWORKDAYS.INTLTAMİŞGÜNÜ.ULUSL
Working days with a custom weekend.
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) - SECONDSANİYE
Second (0–59).
=SECOND(serial_number) - TIMEZAMAN
Builds a time.
=TIME(hour, minute, second) - TIMEVALUEZAMANSAYISI
Converts a time written as text.
=TIMEVALUE(time_text) - WORKDAY.INTLİŞGÜNÜ.ULUSL
Date a number of working days away with a custom weekend.
=WORKDAY.INTL(start_date, days, [weekend], [holidays])
Stop memorising formulas. Describe them.
Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.
Try it free