Suppose you are working in an Excel sheet containing cells with dates. Depending on your actual requirement, one of the things that you might want to do is to extract the day, month, or even the year in a date entry in an Excel cell. For instance, your cell A1 contains the date June 7, 2013. It could have been entered as 6/7/2013 but the cell was format to show the date in a long pattern. But as long as Excel recognizes the data as a DATE, then it stores… Read More