Custom format date
 

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


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=399831

FormatCellsNumber tabcatagory datetype
hth

"bach" wrote:


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


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=399831

bach,

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


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

Sandy

Replace@mailinator with @tiscali.co.uk


"bach" wrote in message
...

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


--
bach
------------------------------------------------------------------------
bach's Profile:
http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=399831

Get a strange string

16t16


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=399831

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

Replace@mailinator with @tiscali.co.uk


"bach" wrote in message
...

Get a strange string

16t16


--
bach
------------------------------------------------------------------------
bach's Profile:
http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=399831

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

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

www.MDOTutorials.com


--
Route2391
------------------------------------------------------------------------
Route2391's Profile: http://www.excelforum.com/member.php...o&userid=26774
View this thread: http://www.excelforum.com/showthread...hreadid=399831