Custom format date

B

bach

Hi Excel Lovers lol,

I would like to format a date input so that the result would be full
day and another to be the following date.

Example

1) Sunday
2) 28 August 2005

Regards
 
S

Sandy Mann

bach,

1) Custom format as "dddd" (without the quotes)


2) Custom format as "dd mmmm yyyy" again without the quotes.
--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
S

Sandy Mann

bach,

You don't say who it is you a replying to. If it is Ray then I think the *
hth * was meant to be * hope this helps *

If it was a reply to me then please post back.

--
Regards

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
R

Route2391

Right Click on the cell and select Cell Properties there you can submi
the particular format and date on refference

I got a lot of my begginer help on this site... cool

www.MDOTutorials.co
 

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

Word VBA - Want to test if Full Name is NOT Present in document 0
List all tables, including document structure 0
MS Project. Real progress of the project, % complete 1
2016 Project, adding a workday to custom field 0
Using colour conditional formatting to show whether due date has past 0
Cobditional Formatting Rows based on dates in action plan. 0
Month days over a time period 5
Grouping {MERGEFIELD} into 2 or 3 Columns 0

Top