Date functions in Excel

  Рет қаралды 856

Codible

Codible

3 жыл бұрын

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 ?
Excel LAMBDA - HOW & WHEN you Should use it
16:02
Leila Gharani
Рет қаралды 429 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 102 М.
ОСКАР vs БАДАБУМЧИК БОЙ!  УВЕЗЛИ на СКОРОЙ!
13:45
Бадабумчик
Рет қаралды 5 МЛН
- А что в креме? - Это кАкАооо! #КондитерДети
00:24
Телеканал ПЯТНИЦА
Рет қаралды 6 МЛН
Дарю Самокат Скейтеру !
00:42
Vlad Samokatchik
Рет қаралды 7 МЛН
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
5 Excel INTERVIEW Questions You NEED to Get RIGHT
8:43
Leila Gharani
Рет қаралды 397 М.
Creating a Histogram in Excel
6:54
Codible
Рет қаралды 41 М.
HARD INDIAN Olympiads Trick | No Calculator Allowed | Can You Try ?
9:09
Learn with Christian Ekpo
Рет қаралды 60
حساب معامل بيتا للشركات وللمحفظة 144420
28:27
ОСКАР vs БАДАБУМЧИК БОЙ!  УВЕЗЛИ на СКОРОЙ!
13:45
Бадабумчик
Рет қаралды 5 МЛН