Formatting a Date String

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
3,893
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
How would I get this result in my cell using vba:

July 11, 2020 Saturday [44023]

I have this, but it's not dropping the '[44023]' portion, which is the serial of that date.

Code:
.Cells(trow, 4) = Format(inq_date, "mmmm dd, yyyy   dddd     [#####]")
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

HappierThan

Board Regular
Joined
Mar 19, 2020
Messages
53
Office Version
  1. 2016
Try removing the square brackets and hash signs. It appears to be doing exactly as shown.
 

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
3,893
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Sorry, I just reread my question. I do want the [44023] included in the string.
That being said, removing the contents as suggested HappierThan won't provide the desired result. I do appreciate the effort.
 

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
3,893
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Code:
.Cells(trow, 9) = Format(inq_date, "dddd dd mmm, yyyy") & "   [" & inq_date & "]"

Thank you.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,342
Messages
5,641,592
Members
417,224
Latest member
llama9207

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top