Using TEXT Function to Show Day Month and Year in Microsoft Excel #shortvideo #excel #short

How to Use The TEXT Function to Display Day Month and Year in Microsoft Excel.

In this video, I use the TEXT function in Excel to separate day, month, and year.

What is the TEXT Function in Microsoft Excel?

The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.

Syntax:
=TEXT(Value you want to format, "Format code you want to apply")

Formula in this video:
To display day:
=TEXT(B3,"dddd")
To display month:
=TEXT(B3,"mmmm")
To display year:
=TEXT(B3,"yyyy")

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
#microsoftoffice #newexcel #excelgyan #besteducation #excelshorts #excelsolution

@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv