View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Current Date Code in form

This will give you the current date:

=TODAY()

and if you want to force the format:

=TEXT(TODAY(),"mm/dd")

However, it wil change every time you open the file on a new day.

Hope this helps.

Pete

On Sep 21, 1:55*pm, Tony wrote:
I want to have the current date to appear in a form formatted as mm/dd. The
textbox name is ProcessDate.