+ Reply to Thread
Results 1 to 5 of 5

getting an error in Month and year from date

  1. 02-09-2017, 09:35 AM #1
    Sanjibghosh
    Sanjibghosh is offline
    Forum Contributor
    Join Date
    07-15-2015
    Location
    Kolkata
    MS-Off Ver
    2010 & 2013
    Posts
    303

    getting an error in Month and year from date

    Getting an error to convert Month & year from date please help me how to resolve it.
    Reply With QuoteRegister To Reply
  2. 02-09-2017, 09:40 AM #2
    BillyRaySpivy
    BillyRaySpivy is offline
    Registered User
    Join Date
    01-20-2017
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: getting an error in Month and year from date

    If A1 contains a date then you can use

    =DAY(A1)
    =MONTH(A1)
    =YEAR(A1)
    Reply With QuoteRegister To Reply
  3. 02-09-2017, 10:20 AM #3
    Sanjibghosh
    Sanjibghosh is offline
    Forum Contributor
    Join Date
    07-15-2015
    Location
    Kolkata
    MS-Off Ver
    2010 & 2013
    Posts
    303

    Re: getting an error in Month and year from date

    i forgot to attached the file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-09-2017, 10:29 AM #4
    JohnTopley
    JohnTopley is online now
    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,404

    Re: getting an error in Month and year from date

    See

    http://www.excelforum.com/showthread.php?t=1173228
    Reply With QuoteRegister To Reply
  5. 02-09-2017, 11:13 AM #5
    BillyRaySpivy
    BillyRaySpivy is offline
    Registered User
    Join Date
    01-20-2017
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: getting an error in Month and year from date

    Maybe this will be of help to you. I split the cells into dates and times. There are no errors showing.
    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. getting an error in Month and year from date
    By Sanjibghosh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-09-2017, 09:00 AM
  2. =DATE(YEAR, MONTH, DAY) stop month increasing.
    By oneblondebrow in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2016, 09:32 AM
  3. Sort month/date/year data using month and date only
    By SMW820 in forum Excel General
    Replies: 8
    Last Post: 11-18-2014, 08:39 AM
  4. How can i show date in this form (month,last date of that month, Year)?
    By vjharry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2014, 04:39 AM
  5. Need to convert Month/Date/Year to Year/Month/Date so excel will recognize
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2014, 04:17 PM
  6. 'Year To Date' outlook using month and year
    By oshodibo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2014, 04:23 AM
  7. Keep month and date but change year to current year and reoccur when new year rolls over.
    By cdixon01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2013, 10:49 AM

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