+ Reply to Thread
Results 1 to 3 of 3

Formula to display certain date

  1. #1
    Registered User
    Join Date
    10-05-2017
    Location
    Windhoek, Namibia
    MS-Off Ver
    2010
    Posts
    1

    Formula to display certain date

    Im working on a template for a budget on excel.

    It is divided by month (January, February ect...)

    I need help with a formula to display the starting date of each budget month.

    For instance:
    The year is "2018"
    The month is "January"
    The first day of that month is "01"

    I need a formula te check in the Year cell and see it is 2018

    It must then check the Month Cell which will contain text (January, February ect...) and determine the numerical value for that month (January = "01")

    Then it must return the starting date for that months budget, for example "01/01/2018" in this case.

    Any help will be greatly appreciated please as this is rather urgent.

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula to display certain date

    Try this
    Enter in D1
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Format as Date
    v A B C D
    1 2018 January 1 1/1/2018
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: Formula to display certain date

    Try

    =DATE(E1,MONTH(F1&0),1)

    E1=2018

    F1=January ( whatever month)

+ 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. [SOLVED] Use formula to display many date on a column.
    By thaimic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2017, 12:43 AM
  2. [SOLVED] Formula to add day in date display
    By rizmomin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-12-2016, 09:58 AM
  3. Replies: 2
    Last Post: 04-23-2014, 09:07 AM
  4. Replies: 1
    Last Post: 03-16-2011, 11:05 PM
  5. Replies: 3
    Last Post: 02-26-2009, 04:28 PM
  6. formula to display the date
    By Stevesmith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2007, 03:07 PM
  7. [SOLVED] Hours and minutes display as date in formula box
    By Dave in forum Excel General
    Replies: 13
    Last Post: 07-28-2006, 02:55 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1