Скачать или смотреть Current Day, Month, Year and Date in

How to Display Current Day, Month, Year, and Date in MS Excel.

In this video, I display the current day, month, year, and date using the DAY, MONTH, YEAR, and NOW functions in Microsoft Excel.

What is the DAY function in Excel?
Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.
Syntax:
DAY(serial_number)
Formula in this video:
=DAY(NOW())

What is the MONTH function in Excel?
Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
Syntax:
MONTH(serial_number)
Formula in this video:
=MONTH(NOW())

What is the YEAR function in Excel?
Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999.
Syntax:
YEAR(serial_number)
Formula in this video:
=YEAR(NOW())

What is the NOW function in Excel?
Returns the serial number of the current date and time. If the cell format was General before the function was entered, Excel changes the cell format so that it matches the date and time format of your regional settings. You can change the date and time format for the cell by using the commands in the Number group of the Home tab on the Ribbon.
Syntax:
NOW()
Formula in this video:
=NOW()

Thank you for watching my video. I hope to see you again in my next video.
If you have any questions please write in the comment below.
♥️📖📖♥️
------------------------------------------------
#msexcel #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #shortvideo #shortfeed #short #shorts #shortsviral #shortsyoutube #share #knowledge #knowledgesharing #exceleasy #excelformula #exceleducation #excelknowledge #date #excelshorts #excelschool
@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv