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.
What else can I help you with?
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 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 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 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 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.
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))
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.
What is the formula for PVIFA in Excel?
The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.
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.
