Basic Date functions in Excel

Опубликовано: 30 Июль 2026
на канале: Zillion Trainings
390
20

NOW function returns the current date and time, updated continuously when a worksheet is changed or opened.

DAY function returns the day of the month as a number between 1 to 31 from a given date.

MONTH function extracts the month from a given date as number between 1 to 12.

YEAR function returns the year component of a date as a 4-digit number.

HOUR function returns the hour component of a time as a number between 0-23.

MINUTE function extracts the minute component of a time as a number between 0-59.

SECOND function returns the second component of a time as a number between 0-59.

#shorts #short #shortvideo #shortsfeed #shortsvideo #shortsyoutube #shortfeed #shortvideos #zillion #zilliontrainings #trainingshorts #excel #exceltutorial #sabur #saburudeen #saboor #exceltips #exceltricks #excelformula #excelformulas