Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am having trouble formatting a date to show only the
current month. If I use Month(Now) then I get a number
value I would like to use the full month text format. I
have been trying to use the following code, but it is not
working.

Acval= Format(Month(Now), "mmmm")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

please help me format this date to Month and Year 4
Get Month name from Date value in cell 7
Excel Vba to change displayed year automatically. 14
Excel Message box with days of month & date. 1
Months between two dates 5
Check Input for Valid Month 4
Date Variable 6
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Back
Top