Day and date

  • Thread starter That's Confidential
  • Start date
T

That's Confidential

In a cell, I want to enter a function which will autofill the day and the
specific date. I know of the =TODAY(), however does anybody know how I can
get the day to appear to? Ideally, I would like Excel to automatically fill
in, eg. Wednesday, 23 May 2004.

Thanks in advance
 
B

Bob Phillips

Format it as dddd, dd mmm yyyy

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top