Thread: How do a set the current date to change in cell everyday
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote