0
You can use the WEEKDAY function, which will give a number from 1(Sunday) to 7(Saturday), to indicate the day of the week. So say your date was in cell A2, then the function could be put into another cell, like this:
=WEEKDAY(A2)
You can also format the date to show the day in different ways. See the related question below.
Add your answer:
Earn +20 pts
How do you add date stamp on excel?
Try this formula: =NOW() If you don't want the time, the formula is =TODAY()
How do you format a cell in micro soft excel to automatically update the day month and year every time it opens?
Type this formula in the cell (including the 'equals' signand the empty parentheses):=TODAY()Then, make sure the date in your computer is correct.That's the only way Excel knows the date.
What is date series in Excel?
A date series is used to fill a series with dates. The date can be increased by either a day, a week, a month or a year each time. This is one of the Fill Series options Excel provides.
What is a a cool excel formula you know?
Put your date of birth in cell A1 as a date. Then in cell A2 type the following formula:=weekday(A1)You will get a number between 1 and 7, telling you what day of the week that you were born on.1 is Sunday2 is Monday3 is Tuesday4 is Wednesday5 is Thursday6 is Friday7 is SaturdayYou can put any date into A1 and it will give you the correct day in A2. Try today's date, by holding the Ctrl key and then pressing the ; key.
What happens when Excel assigns a formula value to the date?
This question is not clear. You can use dates in a formula, but you can not assign a formula value to a date. If you are trying to use dates in formulas, use them like you would any other number. If A1 contains a date, you can show the date six days earlier by using the formula =A1-6.
What excel formula do I use to show if a audit is expired or in date or there is no audit date on file?
=IF(G17="","No Audit on File",(IF(G17>TODAY(),"Valid","Expired"))) Works!!
What do you have to put in a cell to denote an equation in Excel?
In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.
How do you change 20130113 to a date format in Excel?
First you need to extract the 3 parts from it for the year, month and day. After that you can use the DATE function to make it into a date. You can then format that cell into a date format. So if 20130113 is in cell A2, then in another cell you could use this formula: =DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
How do you insert a current day vertical line to an Excel spreadsheet?
go into the address bar and i think you type in a certain formula and it should give you your current date and time, longitude and latitude (if you allow it) in a moment or two.
What is the shortcut to enter the date in Excel?
The formula is =NOW(). Ensure you format the cell to display the date format you want.
Where is the formula error button in Excel 2007?
There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.
If you have an excel template with automatic date you want that the saved document dont change the date only the template do is there a formula?
I you have a worksheet that updates the date in a cell to the current date, edit the cell to change to the date you want displayed. Most likely, the cell is using the formula =NOW() or some other date function to automatically assign a date to the worksheet. When you replace the formula with the date you want to display, your date will remain until you change it.
