DATE FUNCTION

DATE FUNCTION

  1. DATE:

    • The DATE function in Excel is used to create a date value based on the provided year, month, and day.
    • It takes three arguments: year, month, and day.
    • For example, the formula “=DATE(2023, 7, 4)” would return the date July 4, 2023.

  2. TODAY

    • The TODAY function returns the current date as a date value.
    • It doesn’t require any arguments.
    • For example, if you use the formula “=TODAY()” today, it will return the current date.
      • TODAY TASK FILE 

  3. DAY

    • The DAY function extracts the day value from a given date.
    • It takes a date as its argument.
    • For example, if you use the formula “=DAY(A1)” where cell A1 contains the date July 4, 2023, it will return the day value 4.
      • DAY TASK FILE 

  4. NOW

    • The NOW function returns the current date and time as a date and time value.
    • It doesn’t require any arguments.
    • For example, if you use the formula “=NOW()” today, it will return the current date and time.
      • DAY TASK FILE 

  5. MONTH

    • The MONTH function extracts the month value from a given date.
    • It takes a date as its argument.
    • For example, if you use the formula “=MONTH(A1)” where cell A1 contains the date July 4, 2023, it will return the month value 7.
      • MONTH TASK FILE 

  6. YEAR

    • The YEAR function extracts the year value from a given date.
    • It takes a date as its argument.
    • For example, if you use the formula “=YEAR(A1)” where cell A1 contains the date July 4, 2023, it will return the year value 2023.
      • YEAR TASK FILE 
 
%d