PDA

View Full Version : how to get today's date in text format?



jeff06
06-27-2007, 10:49 AM
I want today's date showing in a textbox like
6/27/2007.
How can i do that?
Thanks

mvidas
06-27-2007, 11:06 AM
Hi Jeff,Format(Date, "m/d/yyyy")

jeff06
06-27-2007, 12:05 PM
Thank you very much, Matt!

mperrah
07-04-2007, 01:15 AM
If you wanted to type a formula in a cell in the worksheet
instead of vb you could use (although of course vb is so totaly awsome):

=text(today(), "m/dd/yyyy")
the text formula is used as text(value, "format_text")
format being:
d = single digit for day (7)
dd = leading zero for day (07)
ddd = three letter name of day (Mon)
dddd = full name (Monday)
m = single digit month (6)
mm = leading zero on month (06)
mmm = three digit name of month (Jun)
mmmm = full name (June)
y or yy = leading zero year (07)
yyy or yyyy = full year in numbers (2007)


I saw this was solved but
I just used this recently thought to put it out there.

Where I have today() can be substituted for a typed out date,
or a reference to another cell, or a named cell reference.

hope this helps

Mark