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

Date and Time

YEAR

  • May 31, 2023
Definition: The YEAR function in Excel is used to extract the year from a date. Syntax: ==YEAR(serial_number). Situation: This formula is appropriate in situations where you need to...
Read More

YEARFRAC

  • May 31, 2023
Definition: The YEARFRAC function in Excel is used to calculate the fraction of a year between two dates. Syntax: ==YEARFRAC(start_date, end_date, [basis]). Situation: This formula is appropriate in...
Read More

TODAY

  • May 31, 2023
Definition: The TODAY function in Excel is used to return the current date. Syntax: ==TODAY(). Situation: This formula is appropriate in situations where you need to get the...
Read More

WEEKDAY

  • May 31, 2023
Definition: The WEEKDAY function in Excel is used to return the day of the week for a given date. Syntax: ==WEEKDAY(serial_number, [return_type]). Situation: This formula is appropriate in...
Read More

WORKDAY

  • May 31, 2023
Definition: The WORKDAY function in Excel is used to calculate the date that is a specific number of workdays from a given date. Syntax: ==WORKDAY(start_date, days, [holidays]). Situation:...
Read More

TIMEVALUE

  • May 31, 2023
Definition: The TIMEVALUE function in Excel is used to convert a text string that represents a time to a serial number that Excel can recognize as a time....
Read More

TIME

  • May 31, 2023
Definition: The TIME function in Excel is used to create a time with hour, minute, and second values. Syntax: ==TIME(hour, minute, second). Situation: This formula is appropriate in...
Read More

NOW

  • May 31, 2023
Definition: NOW is a function that returns the current date and time. Syntax: =NOW() Situation: This formula is appropriate when you need to get the current date and...
Read More

MINUTE

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

MONTH

  • May 31, 2023
Definition: MONTH is a function that returns the month component of a given date. Syntax: =MONTH(serial_number) Situation: This formula is appropriate when you need to find the month...
Read More