Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2021, 08:06 PM
allenmfry1986@gmail.com allenmfry1986@gmail.com is offline Anyone tell me how to insert the corresponding day of week for this date and time code? Windows 10 Anyone tell me how to insert the corresponding day of week for this date and time code? Office 2019
Novice
Anyone tell me how to insert the corresponding day of week for this date and time code?
 
Join Date: Nov 2021
Posts: 1
allenmfry1986@gmail.com is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-18-2021, 10:16 PM
Guessed's Avatar
Guessed Guessed is offline Anyone tell me how to insert the corresponding day of week for this date and time code? Windows 10 Anyone tell me how to insert the corresponding day of week for this date and time code? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone tell me how to insert the corresponding day of week for this date and time code? 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
Anyone tell me how to insert the corresponding day of week for this date and time code? Shortcut for date/time insert normle Office 4 03-23-2012 05:15 AM
Anyone tell me how to insert the corresponding day of week for this date and time code? default font for date and time insert kennystringer Word 2 12-21-2011 12:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft