Day and month in excel

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.

Replies (1)

EXcellent!!

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details