the function FORMAT()

[Guest]

We used to have this function in the previous MS Excel and MS Acess whereby
to format a date in a formula like ="today
is:"&FORMAT(today(),"ddd/mmmm/yyyy"). apparently this function disappeared??

 

[Bob Phillips]

You can have

=TEXT(today(),"ddd/mmmm/yyyy")

in a worksheet, or

FORMAT(Date,"ddd/mmmm/yyyy")

in VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)

We used to have this function in the previous MS Excel and MS Acess whereby
to format a date in a formula like ="today
is:"&FORMAT(today(),"ddd/mmmm/yyyy"). apparently this function

disappeared??