How to convert date into Day, Month and Year in Excel || DAY,MONTH,YEAR & TEXT FUNCTION IN EXCEL

How to convert date into Day, Month and Year in Excel || DAY,MONTH,YEAR & TEXT FUNCTION IN EXCEL
Quickly Split Date Into Day, Month And Year In Excel
#excel_tipsandtricks
FUNCTIONS USED IN THE VIDEO:-
=day() for Day(Number)
=month() for Month(Number)
=year() for Year(Number)

TEXT FUNCTION:
=day(..,"dddd) for Day(Text)
=month(..,"mmmm) for Month(Text)
=year(..,"yyyy") for Year(Text)

NOTE:
Year(Number) = Year(Text) = SAME RESULT

If you have any questions or queries, you can comment below.
Sharing is Caring
Have a great day.