+ Reply to Thread
Results 1 to 7 of 7

Display date within month only

  1. 02-07-2024, 06:04 AM #1
    syed82 is offline
    Forum Contributor
    Join Date
    07-30-2010
    Location
    Malaysia
    MS-Off Ver
    Microsoft Office Standard 2016 (Windows 10 Pro SOE Version 1.5 April 2021)
    Posts
    101

    Display date within month only

    Hi,
    I have receive assistance from one of the forummer here.
    the formula is working great for working day date. Also i have a question/request, how to get whole date in that month as well.

    sample attached for easy reference, "column C" is require your expertise
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-07-2024, 06:06 AM #2
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,403

    Re: Display date within month only

    Do you still have the ancient Excel 2003?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 02-07-2024, 06:12 AM #3
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,403

    Re: Display date within month only

    Try this in C4 copied down:

    =IF(ISTEXT(C3),A2,IF(C3+1>EDATE(A$2,1)-1,"",C3+1))
    Reply With QuoteRegister To Reply
  4. 02-07-2024, 06:14 AM #4
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,403

    Re: Display date within month only

    For Excel 365, if you have it:

    =SEQUENCE(EDATE(A2,1)-A2,,A2)

    You'd need to clear all results first, though.
    Attached Files Attached Files
    Last edited by AliGW; 02-07-2024 at 06:16 AM.
    Reply With QuoteRegister To Reply
  5. 02-07-2024, 06:50 AM #5
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,403

    Re: Display date within month only

    Any response? What's your current Excel version? Was either of my suggestions of any use to you? Do you have any further questions?
    Reply With QuoteRegister To Reply
  6. 02-07-2024, 07:51 AM #6
    syed82 is offline
    Forum Contributor
    Join Date
    07-30-2010
    Location
    Malaysia
    MS-Off Ver
    Microsoft Office Standard 2016 (Windows 10 Pro SOE Version 1.5 April 2021)
    Posts
    101

    Re: Display date within month only

    sorry for delay in response.
    My current excel version is 2016. and 1st formula is working.
    Thanks and with sample provide by your goodself this will assist me understanding "EDATE" formula
    Last edited by AliGW; 02-07-2024 at 07:54 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
    Reply With QuoteRegister To Reply
  7. 02-07-2024, 07:54 AM #7
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,403

    Re: Display date within month only

    You're welcome, but PLEASE update your forum profile to Excel 2016.

    Glad to have helped.

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
    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. [SOLVED] Display a value if the date o.t. month in the cell left of it is a certain day o.t. month
    By larsvane in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-18-2024, 06:05 AM
  2. Formula to display a Month based on a given date (and just the month)
    By Gooford in forum Excel General
    Replies: 4
    Last Post: 05-13-2022, 01:28 PM
  3. [SOLVED] Extract month from date, have it display as 'Jan', and have excel read it as a month.
    By kufta4 in forum Excel General
    Replies: 5
    Last Post: 01-24-2019, 05:30 PM
  4. [SOLVED] Display the first date of the month when the month and year are selected
    By john dalton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2013, 11:59 AM
  5. [SOLVED] How to display only the month when given date value
    By gmatoka in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-06-2013, 10:17 PM
  6. Display end of month date for previous month
    By erikwvb in forum Excel General
    Replies: 3
    Last Post: 06-20-2011, 01:22 PM
  7. How to get a cell to display the date of the first day of the month
    By bugmenot in forum Excel General
    Replies: 2
    Last Post: 07-22-2009, 01:59 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1