Thread: Date Range Check

Hi

Could someone help in trying to work out a formula to show when a job is completed within a date range. The data is shown as a date and is described as actfinish, schedstart, schedfinish. I need to know if the actfinish date is equal to or is within the schedstart & schedfinish dates. A summary of the whole list showing % of actfinish dates that fall within the range would be good but also seeing it via a yes or no would be adequate. I have attached the work sheet for reference if required.

Any help is appreciated.


Sched Comp Test.xlsx

Thanks
Rob

Add this formula to cell F2 and copy it down the column:

=IF(ISBLANK(C2),"",IF(AND(C2>=D2,C2<=E2),1,0))

Then add this formula to cell G2 and do the same:

=SUM($F$2:F2)/COUNT($F$2:F2)

Thankyou for your help.