answersLogoWhite

0

You can format a date so that it only shows month and year, but leaves out the day. Select the date cell and open the Format Cells dialog, by pressing Ctrl - 1. Choose custom and then you can type mm-yyyy as the format to show just the month and year for your date.

User Avatar

Wiki User

8y ago

What else can I help you with?

Related Questions

How do you time stamp a cell in Microsoft Excel?

You do not. Excel does not record the change date of an individual cell.


How to determine the number of months worked in excel?

=MONTH(date) returns a number of the month (1-12).


How old are you if your birthday is February 15 1987?

On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.On the date this question is being answered, the 20th of October 2014, someone born on that date would be 27 years and 8 months old.


In excel What must you do in the pivot table report to bring up to date after you change the source information?

Refresh it.


When opening an Excel file in a different year will it automatically save to present year?

The short answer is maybe, but you will not change the file date just by opening the file. When you save a file, it will display the date and time when you saved it (as set in your computer date-time settings). Excel will ask you if you want to save the file when you exit (assuming you did not change the default settings). You can choose to leave the file as is (same file date) or save the file (current file date). An exception to this would be determined by your auto save settings on Excel. If you make any changes to the file, Excel might automatically save the file (thus, changing the file date). Additionally, windows may save the last-accessed date. Bottom line, if you want to view an Excel file and not change the date, save the file to a different name as soon as you open it. Then examine the file copy.


How many day years hours and minutes old are you if your birth is October 112001?

That's a moving target, of course, since your birth date and time are fixed, but "now" continues to change. You can use a spreadsheet (such as Excel or Open Office Calc) to perform these calculations. If your birth date and time are in cell A1, the calculation "=now()-A1" will display your age in days and decimal days. You can then use other functions to convert this to years, months, hours or minutes.


How do you make cells change color automatically depending on what date is entered in 2007 excel?

Use conditional formatting to set the condition when you enter a particular date.


How many years did Diana and Prince Charles date?

6 months


When you enter a date excel assigns a what value to the date?

numerical


When you enter a date Excel assigns a?

a serial value to the date


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.


How do you show today's date in a cell in Excel?

Format / Cells / Date