| one4gatr |
| I cant seem to figure this one out and was hoping some expert on this board can help me. I am trying to figure out how to get cell in excel to auto update to the current date. Example I use a spreadsheet every day but each day I need to go to the cell that has the date and change it from 2/27/07 to 2/28/07 etc... I know MS Word has this function but I cant seem to find a formula or navigate from the menu to make this happen. Thanks in advance. |
|
|
| cardingtr |
Autodate:
here, try this: =LEFT(TEXT(TODAY)()+COLUMN()-1,"ddd),1)
put that formula in a cell and let me know.
quote:
Originally posted by one4gatr
I cant seem to figure this one out and was hoping some expert on this board can help me. I am trying to figure out how to get cell in excel to auto update to the current date. Example I use a spreadsheet every day but each day I need to go to the cell that has the date and change it from 2/27/07 to 2/28/07 etc... I know MS Word has this function but I cant seem to find a formula or navigate from the menu to make this happen. Thanks in advance.
|
|
|
| ByeByeChrysler |
try
=NOW() |
|
|
| one4gatr |
quote:
Originally posted by ByeByeChrysler
try
=NOW()
Beauty... works like a champ.
cardingtr- I couldnt get yours to work.
Thanks this has been driving me crazy for two weeks. |
|
|
| cardingtr |
or try: =today()
that will show the date only without the time.
the other formula is for sequencing i thought of first you needed.
quote:
Originally posted by one4gatr
Beauty... works like a champ.
cardingtr- I couldnt get yours to work.
Thanks this has been driving me crazy for two weeks.
|
|
|
| one4gatr |
quote:
Originally posted by cardingtr
or try: =today()
that will show the date only without the time.
the other formula is for sequencing i thought of first you needed.
When I put that first formula in it said I had too many arguments. The =now() isnt populating time on my spreadsheet. Maybe its because I have the cell formatted at mm/dd/yyyy I dont know.
But again thanks a ton. I cant believe I wasnt able to find something this simple in the Excel help section. Oh well. |
|
|
| mdxx3 |
| ^^ be sure the cell is set to General type of format. Select/click the cell, then press Ctrl_1. In the "Number" tab near the top, be sure it is in "General" (or something else that's compatible). Then close this formatting box, and re-type the formula (or edit the line/formula and press Enter). (??) |
|
|
|
