+ Reply to Thread
Results 1 to 5 of 5

Formula to write day and month from a timestamp

  1. 07-14-2022, 09:08 AM #1
    rexcel548562
    rexcel548562 is offline
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Formula to write day and month from a timestamp

    Hi,

    I have timestamps in column C. I want to write their Day and Month in column D from D3 onward.

    Please see attached file for more clarification
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-14-2022, 09:11 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Formula to write day and month from a timestamp

    This is done with:

    =LEFT(C3,10)+0
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 07-14-2022, 09:16 AM #3
    HariArvi
    HariArvi is offline
    Registered User
    Join Date
    06-22-2022
    Location
    India
    MS-Off Ver
    Microsoft office Home and Student 2019
    Posts
    61

    Re: Formula to write day and month from a timestamp

    Hi,

    Try this formula:
    =TEXT(MID(C3,1,10),"DD-MMM")
    Reply With QuoteRegister To Reply
  4. 07-14-2022, 09:19 AM #4
    rexcel548562
    rexcel548562 is offline
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Re: Formula to write day and month from a timestamp

    Hi Sir Glenn Kennedy,

    Thank you very much it worked perfectly.
    Reply With QuoteRegister To Reply
  5. 07-14-2022, 09:21 AM #5
    rexcel548562
    rexcel548562 is offline
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Re: Formula to write day and month from a timestamp

    Hi HariArvi,

    Thank you so much. This formula also worked perfectly.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to identify consecutive month of GP write down
    By jharvey87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2021, 03:10 PM
  2. [SOLVED] Collate no. of records and first and last timestamp per day of a month
    By DevfromCorrie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2018, 11:18 AM
  3. How to write the Formula for calculation day of inventory when month has change
    By Akatecho in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-20-2014, 02:28 PM
  4. How do i write a formula to count the number of days in a date range, split per month
    By benwwatson in forum Excel General
    Replies: 8
    Last Post: 12-04-2013, 04:14 AM
  5. Function to write Data to DB from specific rows and colomuns Plus specific Timestamp
    By Mudhafar.M in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 08:01 PM
  6. [SOLVED] How to write a formula to return a value based on a set date every month
    By Dena in forum Excel General
    Replies: 4
    Last Post: 09-06-2012, 12:04 PM
  7. write a sublist and tabulate timestamp next to matching value in list
    By anansi boy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-31-2012, 12:19 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1