+ Reply to Thread
Results 1 to 5 of 5

can someone help me please ?

  1. #1
    Registered User
    Join Date
    04-15-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    30

    can someone help me please ?

    hi

    when i type formula is "=today()" in cell ; Returns the serial number of the current date !
    so i wanted to give the first day of month and the end day of month in the current date

    what an i do ?

    for example :

    current date is 12/29/2012
    so first day of month above is : 12/01/2012
    and end day of month above is : 12/31/2012

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: can someone help me please ?

    Hi termal,


    suggest you to change the thread title to reflect the query you are asking.. see the forum rules:-
    http://www.excelforum.com/forum-rule...rum-rules.html


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: can someone help me please ?

    if you want to get first date of todays month
    =EOMONTH(TODAY(),-1)+1

    and for last date
    =EOMONTH(TODAY();0)

  4. #4
    Registered User
    Join Date
    04-15-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: can someone help me please ?

    thanks Ghozi Alkatiri

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: can someone help me please ?

    hi Ghozi Alkatiri,
    you know...you should not ignore what dilipandey posted above!

    termal?
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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