Results 1 to 6 of 6

Formula to calculate the FTE Month on Month

Threaded View

  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.

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