answersLogoWhite

0

You can format cells to show the day of the week of a particular date. Select the dates or cells you want to format. Go to the Format Menu or press Ctrl and the 1 key. Then go the the Number tab and then scroll down to Custom. In the Type box type:

dddd dd mmmm yyyy

The dates you have selected will show the day as a word and also the month as a word. If I did that for today when I am answering the question it will display:

Saturday 12 December 2009

The dddd represent the day as a word. The dd represents the number of the day. The mmmm represents the month as a word and the yyyy shows the year. You can re-arrange them to show it the way you want. To get Saturday December 12 2009 you would put:

dddd mmmm dd yyyy

If you type the d or m three times instead of four, it will show the day or month with the first three letters only.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

The autocorrect feature in excel capitalizes the first letter in names of days?

To disable the autocapitalization feature in Excel for names of days, you can go to the File menu, select Options, choose Proofing, and click on AutoCorrect Options. From there, you can uncheck the option that says "Capitalize the first letter of sentences" which should prevent Excel from automatically capitalizing the first letter in names of days.


How many days old are you if you were born September 25 2000?

Actually, the answer changes from day to day. - You can do date calculations in Excel. Just put two dates in two different cells; in a third cell, subtract the two dates. The difference between two dates, in Excel, is the number of days elapsed.


Can Excel cells formatted as dates be used in calculations?

Yes they can be. A lot of calculations are done on dates, like finding out how may days there are between two dates.


When is day 1 in Excel in PC?

All dates on Excel have a numeric value. The 1st of January 1900 has the value of 1. All dates are counted off from that date. By giving dates numeric values, it is possible to do calculations with dates, like finding how many days are between two dates.


How can I use the 30 360 day count calculator in Excel to calculate interest payments accurately?

To use the 30/360 day count calculator in Excel for accurate interest payment calculations, input the start date, end date, and the interest rate. Excel will automatically calculate the number of days between the dates based on the 30/360 day count convention, allowing you to determine the interest payment amount more precisely.


How many days from today to 7 of July 2014?

1108 Days. You can calculate it from excel. Just enter two dates into two cells & deduct one from other.


What does the DAYS360 function inside excel do?

It returns the amount of days between two dates based on a year of 12 months with 30 days. It is a method used for some calculations in the accounting business.


How far is SeattleWashigton from excel?

my guess is 7 days


Which Excel tool would you have to use to automatically write the days of the week Explain how would you do it?

You can use the Fill handle. Type any day of the week into a cell. Then put the cursor over the Fill handle and drag down or right. The subsequent days of the week will fill into the other cells.


How can I use the 30/360 interest calculator in Excel to determine the total interest accrued on a loan or investment?

To use the 30/360 interest calculator in Excel, you can input the loan amount, interest rate, and the number of days to calculate the total interest accrued. Excel will automatically calculate the interest based on a 30-day month and a 360-day year, providing you with the total interest amount on the loan or investment.


What is the purpose of List Manager in Excel?

It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.It lets you manage lists in Excel. You can set up special Custom Lists and do things like sort them or get calculations from them or get them to automatically generate themselves when you type in one value and then drag down. There are a number of in-built custom lists in Excel for things like days of the week and months of the year. You can work with data and use list management options to do things with the data, like linking with other applications and files.


When you enter a date Excel assigns a what value to the date which makes it possible to treat dates like other numbers for the purpose of calculating the number days between two dates?

In Excel every cell contains what is seen (value) and what is not seen (formula) and in most cases these are the same thing. When you enter a date in the cell Excel recognizes this and instantly converts the date into a single number whose value represents the number of days from January 1, 1900. You can format the cell to still appear as a date but the formula contains this number which makes it easy to compare or sort against other cells also containing dates.