+ Reply to Thread
Results 1 to 2 of 2

Date formatting update - how to update a formula/format to properly display a date field.

  1. #1
    Forum Contributor
    Join Date
    03-19-2016
    Location
    Chicago, IL
    MS-Off Ver
    Office 2016 Professional
    Posts
    388

    Date formatting update - how to update a formula/format to properly display a date field.

    Here is my example:

    Raw Data in Column BM: 1/25/2017
    Formula in Column BN: =MONTH(BM2)
    Column BN displays a '1', in this example.

    How would I update Column BN to display the month differently (Jan instead '1', Feb instead of '2', etc.)

    I tried using a custom format (mmm), but I have been unable to get the formula to drag down (it keeps populating all values with 'Jan' instead of the actual expected month.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Date formatting update - how to update a formula/format to properly display a date fie

    you can try with =TEXT(BM2,"mmm")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Update given date column in general format to date format in VBA
    By l3sushi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2016, 02:32 PM
  2. Replies: 2
    Last Post: 10-13-2014, 02:11 PM
  3. Date Format Of User PC Changes Display format date of Excel File after update
    By waihar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2014, 03:09 AM
  4. Excel to automatically update field using date
    By Stevie4man in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-09-2014, 10:24 AM
  5. setting date field to not auto update
    By sideshow bob in forum Excel General
    Replies: 1
    Last Post: 02-16-2010, 01:46 PM
  6. Creating an overdue date field to update data automatically
    By simjambra in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-05-2009, 12:19 AM
  7. conditional update to date field
    By smurphy812 in forum Excel General
    Replies: 5
    Last Post: 11-06-2006, 05:04 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1