the function FORMAT()

J

Jonas

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??
 
B

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)


Jonas said:
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
Click to expand...
disappeared??
 
Top