Hi,
I'm new to this Forum and I'm hoping someone can help me resolve this nested formula issue.
I'm trying to create a nested IF formula to return a number if a date falls within a given date range. The following formula works for the following start and end date if the date chosen is 3/31/13, but not subsequent months (4/30, 5/31, etc.):
Start Date: 3/21/13 End Date: 5/31/13
=IF(MONTH(F$71=$B$87),IF(AND(F$71>=$B$87,F$71<=$C$87),'Project Staffing Projections'!$F$41/30*(F$71-$B$87),'Project Staffing Projections'!$F$41),IF(MONTH(F$71=$C$87),'Project Staffing Projections'!$G$41,0))
This formula accounts for the partial Staffing Projections for the month of March (10 days), but does not work for following months correctly.
How can I rewrite this formula to show that if, let's say, 6/30/13 doesn't fall within 3/21/13 and 5/31/13, projections should be zero?
Thanks!
Bookmarks