Results 1 to 4 of 4

Thread: Need help in formula

  1. #1

    Need help in formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Friends,

    I am new for this forum and very glad to be member in this professional forum to hone excel skills.

    I request you all kindly help me out regarding the following query.

    If we want to change the existing column dates as one common date without changing of Month and Year to another column, how can we do that in an excel sheet.
    I need to prepare a report where I need to indicate date as first of every month without changing the month and year in another column.

    Herewith attached an excel sheet for your ready reference. Hence request you all help me out for the same.


    Your valued support in this regard would be highly appreciated.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    120
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    Try this:

    Code:
    =DATE(YEAR(B2),MONTH(B2),1)
    Autofill down.

    If you want to use a different day, change the "1" to the day you prefer.

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,463
    Articles
    0
    Excel Version
    Excel 2016
    These formulas will do that:

    =EOMONTH(B2,-1)+1

    or

    =DATE(YEAR(B2),MONTH(B2),1)


  4. #4
    Dear Friends,

    Thanks a lot for your support, it is really useful...............

    Thanks in tons.

    Quote Originally Posted by NBVC View Post
    These formulas will do that:

    =EOMONTH(B2,-1)+1

    or

    =DATE(YEAR(B2),MONTH(B2),1)

Posting Permissions

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