This may be helpful to new articles who are not very familiar to MS-Excel.
While taking out samples or during analysis from any ledger / party dump, if you need day name or month name against a date column, apply the following:
a) insert a column before or after the date column (shortcut is Alt+I+C)
b) type the following formula:
=text(cell reference,"ddd") ------> for short Day
=text(cell reference,"dddd") ------> for long Day
=text(cell reference,"mmm") ------> for short Month
=text(cell reference,"mmmm") ------> for long Month
c) now copy and paste the formula to the whole list.
Reply if you find this helpful.
CAclubindia
