| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do a set the current date to change in cell everyday
Highlight the cells that you want to change then hit:-
Ctrl and the ; key simultaneously. The current date will be placed into the highlighted cells. Please hit Yes if my comments have helped. Thanks! "erie2446" wrote: I have a created a spreadsheet that calulates the number of days between two dates. Since I have 30 entries to track I must change the current date in 30 cells. However, I have to manually change the current date in 30 cells. Is there a formula to automatically change the current day in the cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Date that does not change everyday. | Excel Discussion (Misc queries) | |||
| current date it should intimate cheques due by colour change | Excel Discussion (Misc queries) | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| can macros change cell color daily, i.e. green to red everyday? | Excel Worksheet Functions | |||
![trip_to_tokyo[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
