|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Anyone tell me how to insert the corresponding day of week for this date and time code?
Anyone tell me how to insert the corresponding day of week for this date and time code?
Public Sub StaticTimeStamp() Selection.InsertDateTime _ DateTimeFormat:="MM/dd/yyyy (hh:mm:ss AM/PM)", InsertAsField:=False End Sub |
#2
|
||||
|
||||
DateTimeFormat:="ddd MM/dd/yyyy" will give you Mon 12/31/2021
DateTimeFormat:="dddd MM/dd/yyyy" will give you Monday 12/31/2021
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
On the Ribbon's Insert tab, 'Insert Date and Time' vanished | DavidTheToad | Word | 6 | 12-19-2019 01:16 PM |
OneNote on Android phone View Tags? Enter Date, Time, Date & Time | DrTwinkyEsq | OneNote | 0 | 03-27-2017 07:54 PM |
Shortcut for date/time insert | normle | Outlook | 1 | 03-25-2012 09:30 PM |
Shortcut for date/time insert | normle | Office | 4 | 03-23-2012 05:15 AM |
default font for date and time insert | kennystringer | Word | 2 | 12-21-2011 12:46 PM |