+ Reply to Thread
Results 1 to 5 of 5

Date function- 1st day of month for 2nd full month from start date

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    Elstree
    MS-Off Ver
    2010
    Posts
    8

    Date function- 1st day of month for 2nd full month from start date

    Hi, wondering how I get the following into an excel formula...
    1st day of month for 2nd full month worked from start date, although only after 1/5/2014

    see attachment

    start date date (1st day of month for 2nd full month)
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Date function- 1st day of month for 2nd full month from start date

    Not sure what you are trying to do

    Explain it in a better way with expected result

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Date function- 1st day of month for 2nd full month from start date

    May be this.....
    In D6
    Please Login or Register  to view this content.
    and copy down.

    Is this what you are trying to achieve?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    06-25-2014
    Location
    Elstree
    MS-Off Ver
    2010
    Posts
    8

    Re: Date function- 1st day of month for 2nd full month from start date

    for example if the date was > 1/5/14 the result would be

    1/5/2014 start date then two month- would be 1/7/14
    but if it was a start date of
    9/5/2104 the 2nd full month worked would be 9/8/14, but i want a date returned of 1/8/14


    i only want dates after the 1/5/2014 though to appear..

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Date function- 1st day of month for 2nd full month from start date

    In D9 Cell

    =DATE(YEAR(B9),MONTH(C9),DAY(B9))

    Drag it down...

+ 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. Replies: 2
    Last Post: 03-22-2013, 02:20 PM
  2. Replies: 6
    Last Post: 03-03-2013, 01:41 AM
  3. Array function for date(month), Range Date(month)
    By dluhut in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2013, 05:14 PM
  4. Take user input start date and end date. Create a column for each month between these
    By TheCyrusVirus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2010, 11:46 AM
  5. Replies: 8
    Last Post: 03-29-2010, 09:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1