+ Reply to Thread
Results 1 to 2 of 2

How do you get the month number from a start date?

  1. #1
    Registered User
    Join Date
    01-15-2015
    Location
    Concord, California
    MS-Off Ver
    2013
    Posts
    27

    How do you get the month number from a start date?

    I need a formula to get the month number from the startdate. Not the numerical number of the month name, but the number of the month from the start date. So If I had a date that started on 2/14/2015. Month #1 would be 2/14/2015-3/14/2015. If anyone has the formula I would appreciate it

    date ------------- month #
    date ------------- month #
    date ------------- month #
    date ------------- month #
    date ------------- month #
    Last edited by natenate88; 02-14-2015 at 10:59 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: How do you get the month number from a start date?

    =DATEDIF(StartDate,EndDate,"M")
    Ben Van Johnson

+ 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. [SOLVED] Date function- 1st day of month for 2nd full month from start date
    By vidiotdave in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-25-2014, 05:33 AM
  2. Replies: 2
    Last Post: 03-22-2013, 02:20 PM
  3. Replies: 6
    Last Post: 03-03-2013, 01:41 AM
  4. Find start date of the month
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-31-2012, 07:25 AM
  5. 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

Tags for this Thread

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