Perhaps you're looking for a formula:
=UPPER(TEXT(TODAY(), "DD-MMM-YYYY"))

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"MissH" wrote in message
...
I know absolutely nothing about VBA coding. I am trying to return the date
using the today function in all capital letters. I searched and seen some
VBA coding for this but I don't know the first thing about how to get
started. Can someone help?