+ Reply to Thread
Results 1 to 6 of 6

Formula to calculate the FTE Month on Month

  1. #1
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Formula to calculate the FTE Month on Month

    Hello Team,

    Please help me to find the formula to calculate the number of days between dates.

    I have Project start date and Project End Date against individual names. Each person's start date and end date differs. i am trying to find how many days he is assigned to the project month on month. If he is completely assigned for a month which is 30 days, then its 1 FTE, if its 15 days then 0.5 FTE.

    So if the person is assigned from jan 1st 2019 to Feb 15th 2020, the result would be 1 for all month from Jan 2019 to jan 2020 and it would be 0.5 for Feb 2020.

    So based on the start date and end date i am trying to find a formula that will calculate the number of days the individual is assigned against each month. Attached is a sample data and result is updated manually. Please help.
    Attached Files Attached Files
    Last edited by arun.sj; 07-22-2019 at 09:01 AM.

  2. #2
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: Formula to calculate the FTE Month on Month

    Quote Originally Posted by arun.sj View Post
    Hello Team,

    Please help me to find the formula to calculate the FTE.

    I have Project start date and Project End Date against individual names. Each person's start date and end date differs. i am trying to find how many days he is assigned to the project month on month. If he is completely assigned for a month which is 30 days, then its 1 FTE, if its 15 days then 0.5 FTE.

    So if the person is assigned from jan 1st 2019 to Feb 15th 2020, the result would be 1 for all month from Jan 2019 to jan 2020 and it would be 0.5 for Feb 2020.

    So based on the start date and end date i am trying to find a formula that will calculate the number of days the individual is assigned against each month. Attached is a sample data and result is updated manually. Please help.
    Hi Team, Requesting for help in this.

  3. #3
    Registered User
    Join Date
    08-02-2018
    Location
    India
    MS-Off Ver
    office 365
    Posts
    20

    Re: Formula to calculate the FTE Month on Month

    Hi Arun,
    By using Hlookup we can solve your question. Please find the attachment for your reference.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: Formula to calculate the FTE Month on Month

    Quote Originally Posted by RaviMis View Post
    Hi Arun,
    By using Hlookup we can solve your question. Please find the attachment for your reference.
    Hi,

    I am looking for a formula in the same cells (D2 to M2, D3 to M3, D4 to M4) which can bring the same results. The formula should calculate the number of days with in the given dates..

  5. #5
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: Formula to calculate the FTE Month on Month

    Hi Team, Please help..

  6. #6
    Registered User
    Join Date
    06-24-2018
    Location
    India
    MS-Off Ver
    2016
    Posts
    45

    Re: Formula to calculate the FTE Month on Month

    Please use attachment for the formula and change cell formats from D1 to M1 as done in attachment
    Attached Files Attached Files

+ 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] Formula to calculate sum of column whose order changes from month to month
    By Jnehra in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2019, 11:01 AM
  2. [SOLVED] Calculate a YTD Total based on Reporting Month and Week of Month via drop down selections
    By Miskondukt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2018, 05:14 PM
  3. Macro to calculate Month to year sales based on month selection
    By chandu356 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2017, 09:58 AM
  4. Calculate percentage meeting attendance month by month over the year
    By Carol27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-20-2016, 02:57 AM
  5. Need Formula to Calculate Sale Month Back to Production Month
    By Newbie403 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-13-2015, 05:28 PM
  6. [SOLVED] Lookup month and calculate if specific month value apply
    By D-smoke in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-24-2013, 03:03 AM
  7. [SOLVED] calculate pay checks per month, to get monthly income value for that month.
    By tladd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2012, 09:51 PM

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