| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do a set the current date to change in cell everyday
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a set the current date to change in cell everyday
Try setting a date in just one sheet, (sheet 1 cell A1) and having all the
other sheets set as =a1(sheet1!) 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? -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200910/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a set the current date to change in cell everyday
in the cells that have to have the current date use =Now()
or place =Now() in a single cell (e.g., A1) and have the cells that have the current date point to that cell =A1 "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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a set the current date to change in cell everyday
I think you meant =Sheet1!A1
Gord Dibben MS Excel MVP On Fri, 16 Oct 2009 13:24:29 GMT, "Mattlynn via OfficeKB.com" <u44078@uwe wrote: Try setting a date in just one sheet, (sheet 1 cell A1) and having all the other sheets set as =a1(sheet1!) 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a set the current date to change in cell everyday
=TODAY() will do.
=NOW() gives time as well as date, so you'd get a false result if you try to compare it with today's date. -- David Biddulph berniean wrote: in the cells that have to have the current date use =Now() or place =Now() in a single cell (e.g., A1) and have the cells that have the current date point to that cell =A1 "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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a set the current date to change in cell everyday
Yer - Thanks Gord.
Gord Dibben wrote: I think you meant =Sheet1!A1 Gord Dibben MS Excel MVP Try setting a date in just one sheet, (sheet 1 cell A1) and having all the other sheets set as =a1(sheet1!) [quoted text clipped - 3 lines] 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? -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200910/1 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a set the current date to change in cell everyday
Darn clunky fingers<g
Gord On Mon, 19 Oct 2009 10:42:39 GMT, "Mattlynn via OfficeKB.com" <u44078@uwe wrote: Yer - Thanks Gord. Gord Dibben wrote: I think you meant =Sheet1!A1 Gord Dibben MS Excel MVP Try setting a date in just one sheet, (sheet 1 cell A1) and having all the other sheets set as =a1(sheet1!) [quoted text clipped - 3 lines] 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 | |||
| How do a set the current date to change in cell everyday | Excel Discussion (Misc queries) | |||
| Display Date that does not change everyday. | 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 | |||
Linear Mode
