One way is to input this formula in B2: =TODAY()
Then format B2 as follows: right-click on it, select Format Cells, in Number
tab select Custom, in Type box input "dd mmmm yyyy" (without quotes) and
press Enter. Thereafter B2 would always have today's date in that format. No
need for VBA.

"Brent E" wrote:

Good day,

I am looking for the VBA code that, when run, will place the current date in
B2 using this format:
DD MonthName YYYY

For example: Todays date would read
25 November 2008.

If this format is difficult to achieve, using a standard DD/MM/YYYY format
could work.

Your assistance is appreciated. Thanks.

Cordially,