Date functions in Excel

Поділитися
Вставка
  • Опубліковано 15 чер 2021
  • Walks you through some of the date functions, such as:
    today() - for getting today's date,
    datevalue() - for getting the date from a text field,
    year(), month(), day() and weekday() for extracting year, month or day number from a date,
    date() for joining numbers to get a date,
    workday() - to get the date that is a certain number of working days away from the current date,
    networkdays() - to get the difference in working days between two given dates, and
    datediff() - to get the number of days, months or years elapsed between two dates.

КОМЕНТАРІ • 2

  • @SSS_123
    @SSS_123 2 роки тому

    👌

  • @vivekshanbhag7422
    @vivekshanbhag7422 2 роки тому

    Hello Sir, I watched your video on correlation and covariance of two stock markets which was posted 6 years ago however i wanted to know if we need to show causality for this correlation between them how do you implement that ? I am working on a project and any sort of suggestion would be great. Also is there anyway to get in touch with you other than here on youtube ?