In excel we have TEXT function which can be used for showing day of week.
if want to show day of the week in excel then type below formula
=TEXT(A3,"ddd")
where A3 is cell that contains date for which you want to show day of week.
if you want to show complete day of the week use below formula :
=TEXT(A3,"dddd")
TEXT() function is available in all the version of Microsoft office package.
if want to show day of the week in excel then type below formula
=TEXT(A3,"ddd")
where A3 is cell that contains date for which you want to show day of week.
if you want to show complete day of the week use below formula :
=TEXT(A3,"dddd")
TEXT() function is available in all the version of Microsoft office package.
No comments:
Post a Comment