Forum Discussion
creating a spread sheet for start and stop dates vs. manpower on a project
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 p...
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)