ipadguides.id – Hello, Friend Zona. Changing the date format to days is rarely done. This is because most reports simply use the date to find out what day it is and write it down manually.
However, the problem that often occurs is how to quickly convert dates to days in a single report in Excel. Therefore, Mimin will share an easy way as follows.
Also Read: How To Quickly Delete Double Data in Excel, Really Easy!
- Open your document in Microsoft Excel where you want to edit the date into days.
- Then, write the formula +text(click cell; “DDD”) and Enter.
- After that, just do the same way on the next cell or it can just be drag the cursor.
Easy Way to Convert Date to Day in Excel, Less than 5 Seconds!
That’s Mimin’s review of an easy way to convert date to day automatically in Excel. Try it yourself.
Hopefully this review is useful for Friend Zone. Don’t forget to keep abreast of information about students and the world of lectures and turn on notifications. See you later.
Also Read: Easy Ways to Fill Blank Cells According to the Cells Above in Microsoft Excel
Create by ipadguides in category of > Student Room