Skip to content

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

All functions

  • DATETARİHFull page

    Builds a date from year, month and day.

    =DATE(year, month, day)
  • DATEDIFETARİHLİFull page

    Difference between dates ("Y", "M", "D", "YM", "MD", "YD").

    =DATEDIF(start_date, end_date, unit)
  • DAYGÜNFull page

    Day of the month (1–31).

    =DAY(serial_number)
  • DAYSGÜNSAYFull page

    Days between two dates.

    =DAYS(end_date, start_date)
  • EDATESERİTARİHFull page

    Date a number of months before or after.

    =EDATE(start_date, months)
  • EOMONTHSERİAYFull page

    Last day of the month, months away.

    =EOMONTH(start_date, months)
  • MONTHAYFull page

    Month of a date (1–12).

    =MONTH(serial_number)
  • NETWORKDAYSTAMİŞGÜNÜFull page

    Working days between two dates.

    =NETWORKDAYS(start_date, end_date, [holidays])
  • NOWŞİMDİFull page

    Current date and time.

    =NOW()
  • TODAYBUGÜNFull page

    Today's date.

    =TODAY()
  • WEEKDAYHAFTANINGÜNÜFull page

    Day of the week (1 = Sunday; type 2 makes Monday 1).

    =WEEKDAY(serial_number, [return_type])
  • WEEKNUMHAFTASAYFull page

    Week number of the year.

    =WEEKNUM(serial_number, [return_type])
  • WORKDAYİŞGÜNÜFull page

    Date a number of working days away.

    =WORKDAY(start_date, days, [holidays])
  • YEARYILFull page

    Year of a date.

    =YEAR(serial_number)
  • YEARFRACYILORANFull page

    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])

Excel functions →

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