Friday, January 02, 2015

 

Date to corresponding day in MS Excel



Say you put on the date in D20 cell and want to get corresponding day in the previous cell C20. In this case the command to be written at the function box located in the top of excel sheet(just after fx symbol)after you put in your cursor in C20   is as follows:
D20 cell: 1/10/2015
C20 cell: =TEXT(WEEKDAY(D20),"dddd")

Reference:
http://superuser.com/questions/41883/how-do-i-get-the-day-name-into-a-cell-in-excel

Labels:


# posted by Abu Rashid @ 10:31 PM
Comments: Post a Comment



<< Home

This page is powered by Blogger. Isn't yours?