May 06 2021 11:44 AM
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
May 06 2021 11:55 AM
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)