Results 1 to 2 of 2

Thread: Pulling dates from one sheet into another sheets formula - end calculations wrong.

  1. #1

    Question Pulling dates from one sheet into another sheets formula - end calculations wrong.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    So I've inherited this excel sheet that allows sales forecasts that has some complex (to me at least) forumula's to calculate the amount of days a contractor has worked within a given month and calculate the company profits based on their margin.

    I have attached the file below but basically the problems are as follows: -

    1.) Column N in the "Detail" sheet has no calculation for contractors, only permanent staff - I've tried copying the caluclation across from a later month but it's flawed already.
    2.) Column X, Row 11 in the "Detail" sheet has calculated an in-correct value, it should only be calculating based on the 14 possible working days due to the finish date but instead calculates the whole month (22 possible working days).
    3.) Furthermore a change of Row 12 Finish date from 1/10/13 to anything higher results in a whole month calculation also so something is playing up in it's calculation of how many days to multiply by.

    I believe it's something to do with the formula's use of VLOOKUP but I can't figure it out :\

    Any help would be much appreciated, thanks!

    - Cheyne

    Sales Pipeline - FIX ME.xls

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Hope that helps

    Roy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •