Day and date

  • Thread starter Thread starter That's Confidential
  • Start date 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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Day of the week and date 3
Excel Message box with days of month & date. 1
Dates and days of the week 3
Excel Forecasting Dates Out to the Day 3
Day and Date Autofill 7
Add 45 days to a date.... 3
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Combine day text and date problems 6

Back
Top