Category: Excel Function

The EDATE function returns the date before or after the specified months. Formula: =EDATE(start_date, months) Explanations: – Start_date is required, the start date you need to have the date …

The DAYS360 function returns the number of days between two dates based on a 360-day year. Formula: =DAYS360(start_date,end_date,) Explanations: Start_date is required, the start date you need to have …

The YEAR function returns the year of a date. Formula: =YEAR(serial_number) Explanations: Serial_number is required, the date you need to find the year. Cautions: Dates are stored as sequential …

The MONTH function returns the month of a date. Formula: =MONTH(serial_number) Explanations: Serial_number is required, the date you need to find the month. Cautions: Dates are stored as sequential …

The DAY function returns the day of a date. Formula: =DAY(serial_number) Explanations: Serial_number is required, the date you need to find day. Cautions: Dates are stored as sequential serial …

The DATEVALUE function is to convert a date from text format to a serial number. Formula: =DATEVALUE(date_text) Explanations: The date_text is required, which is a date in text format, …