Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Date and Time

NETWORKDAYS

  • May 31, 2023
Definition: NETWORKDAYS is a function that calculates the number of working days between two given dates. Syntax: =NETWORKDAYS(start_date, end_date, [holidays]) Situation: This formula is appropriate when you need...
Read More

HOUR

  • May 31, 2023
Definition: HOUR is a function that returns the hour component of a time value. Syntax: =HOUR(serial_number) Situation: This formula is suitable when you need to find the hour...
Read More

EDATE

  • May 31, 2023
Definition: EDATE is a function that returns the serial number of the date that is a specified number of months before or after a specified date. Syntax: =EDATE(start_date,...
Read More

EOMONTH

  • May 31, 2023
Definition: EOMONTH is a function that returns the serial number of the last day of the month that is a specified number of months before or after a...
Read More

DAY

  • May 31, 2023
Definition: DAY is a function that returns the day of the month for a specified date. Syntax: =DAY(date) Situation: This formula is suitable when you need to retrieve...
Read More

DAYS360

  • May 31, 2023
Definition: DAYS360 is a function that returns the number of days between two dates based on a 360-day year. Syntax: =DAYS360(start_date, end_date, [method]) Situation: This formula is suitable...
Read More

DATE

  • May 31, 2023
Definition: DATE is a function that returns the serial number of a date. Syntax: =DATE(year, month, day) Situation: This formula is suitable when you need to convert a...
Read More

DATEDIF

  • May 31, 2023
Definition: DATEDIF is a function that returns the difference between two dates in months, days, or years. Syntax: =DATEDIF(start_date, end_date, unit) Situation: This formula is suitable when you...
Read More

DATEVALUE

  • May 31, 2023
Definition: DATEVALUE is a function that returns the serial number of a date based on a text string. Syntax: =DATEVALUE(date_text) Situation: This formula is suitable when you need...
Read More