Want to update the dates in excel spreadsheet

Right-click the cells and go to 'Format Cells'. Then, select the correct format. If you're wanting to leave the slash (/) in the number, you'll probably have to make it a text format.

Normally excel should automaticallly update the values on the spreadsheet. However, in certain cases when it doesn't work, you can use the manual update key which is the "F9" key on the keyboard.

Hope this answer your question.

Hi JK,
We have to use the combination of dynamic list and indirect() function.
and offcourse countif() and if().

If you need the solution from me, Please send me the sample sheet on [email protected] so that I can send you the solution sheet.

Zulfikar Ali

here are a few links to show you how to do this

http://www.excelforum.com/excel-programming/366646-how-do-you-create-a-calendar-drop-down-in-excel.html

http://www.fontstuff.com/vba/vbatut07.htm

and a youtube video

Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).

1) Make sure each column in your spreadsheet has a heading.

2) Highlight (select) the column of birthdays.

3) Choose Format from the menu bar.

4) Choose Cells... from the drop-down menu.

5) For the "category", choose Custom.

6) In the "type" box, type yyyy

7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.

8) Now, highlight the entire table

9) Then, choose Data from the menu bar

10) Choose Subtotals... from the drop-down menu

11) In the "At each change in" box, choose the name of the column with the birth dates

12) In the "Use function" box, choose Count

13) Leave all other choices at their defaults

14) Click OK, and you are done.

Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.

I hope this helps.

1. open ur spreadsheet from your files that you want to insert a dynamic date and time
2. select the cell into which you want to insert the dynamic date and time.
3. Type "=now()" (ignore quotation marks) into the selected cell.
4. Press the "Enter" key on your keyboard to enter the formula into the selected cell. You will now see the current date and time appear in the cell you typed the formula into. (Date and time will update every time the "Enter" key is pressed )

.

You can write a macro for that and needs to run every time after opening of the excel sheet.

lok on google for password cracker for excel download and it will open any locked spreadsheet

You need to learn how to use the, "Paste Link," function. If you copy the spreadsheet and paste the information into a new tab in the same workbook, using the 'paste link' feature, the information on the linked pages will update automatically each time you update the page the links are based upon.

The most likely problem is that you (or somebody) has R1C1 reference style turned on.

In the TOOLS menu, choose OPTIONS and switch to the GENERAL tab. Look for the checkbox labeled R1C1 reference style. If it is checked, this will cause your symptoms.

Just uncheck the box and click OK.

I'm not sure what happens to existing formulas. If you (or somebody) has written formulas that rely on the R1C1 style, I don't know if they automatically get updated to the regular style or not, but that should be easy to discover.