Tags Microsoft Excel

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Electronics>Computers

Excel formula from date to day?

Anonymous

∙ 12y ago

Updated: 12/14/2022

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.

Wiki User

∙ 12y ago

Still curious? Ask our experts.

Chat with our AI personalities

Beau

You're doing better than you think!

Chat with Beau

Maxine

I respect you enough to keep it real.

Chat with Maxine

Judy

Simplicity is my specialty.

Chat with Judy

Add your answer:

Earn +20 pts

Q: Excel formula from date to day?

Write your answer...

Submit

Still have questions?

imp

Trending Questions

How does the computer measure KB in a Word document? Who offers quality employee management software? How many fluid ounces are needed to fill a gallon container? What is mobility anchor point in mobile computing? When a formula is in an active cell the underlying formula is visible in the what Formula Bar or Worksheet or Status bar or Name Box? In Microsoft Access if the value 1000.5 is entered in a field in access that has been defined as currency data type then the value will display how? Which type of malware hides in the MBR program of a hard drive? What is the role of an address when used in the context of computer memory? Where can one download the Adobe Acrobat free? Can text constants be in Excel formulas? Where can I find new computers rugged solution in Dubai? Is the Hundred Dresses book a Accelerated Reader book? How much was the first apple computer? Which has greater resistance to transmission errors Binary signaling or Analog signaling? You use the zoom slider to change the zoom percentage? How do routing protocols and routable protocols differ? Do Lenovo laptops offer touch screen displays? What are three factors affect your role in processing incoming mail? What option in the new table dialog box will guide you step-by-step through the process of creating a table? What is any hypothetical person that is using a program and providing input for it?

Related Questions

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.

Still have questions?

imp

Resources

Top Categories

Product

Company

Copyright ©2025 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.