creating a spread sheet for start and stop dates vs. manpower on a project

%3CLINGO-SUB%20id%3D%22lingo-sub-2332439%22%20slang%3D%22en-US%22%3Ecreating%20a%20spread%20sheet%20for%20start%20and%20stop%20dates%20vs.%20manpower%20on%20a%20project%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332439%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20get%20total%20manpower%20to%20auto%20populate%20based%20on%20the%20start%20and%20stop%20dates%20of%20each%20job.%26nbsp%3B%20I%20have%20created%20a%20spread%20sheet%20based%20on%20the%20days%20of%20the%20week%20for%206%20months%20and%20want%20the%20man%20power%20to%20populate%20onto%20the%20spreadsheet%20based%20on%20the%20days%20of%20the%20week.%26nbsp%3B%20The%20man%20power%20should%20populate%20onto%20august%2025%20to%20august%2027%20based%20on%20the%20if%20statement%20but%20instead%20the%20if%20statement%20is%20populating%20all%20zeros%20for%20every%20day.%26nbsp%3B%20How%20can%20I%20fix%20the%20if%20statement%20to%20populate%20the%20Total%20manpower%20into%20the%20correct%20days%20of%20the%20week%20on%20the%20spea%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2332439%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2332537%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20a%20spread%20sheet%20for%20start%20and%20stop%20dates%20vs.%20manpower%20on%20a%20project%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047199%22%20target%3D%22_blank%22%3E%40kirkbohlen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20don't%20understand%20the%20use%20of%20MATCH%20and%20DAY%20in%20your%20formula.%20Try%20this%20simpler%20version%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(AND(V%249%26gt%3B%3D%24J%2411%2CV%249%26lt%3B%3D%24K%2411)%2C%24I11%2C0)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to get total manpower to auto populate based on the start and stop dates of each job.  I have created a spread sheet based on the days of the week for 6 months and want the man power to populate onto the spreadsheet based on the days of the week.  The man power should populate onto august 25 to august 27 based on the if statement but instead the if statement is populating all zeros for every day.  How can I fix the if statement to populate the Total manpower into the correct days of the week on the spea 

1 Reply

@kirkbohlen 

I don't understand the use of MATCH and DAY in your formula. Try this simpler version:

 

=IF(AND(V$9>=$J$11,V$9<=$K$11),$I11,0)