trying to populate rows using formulars that will return blanks when there are no values

[Austine Kings]

I am trying to get this formulars sorted out and i have attached a sample worksheet

Columns highlighted in "Yellow" are to return either YES or NO

1. column D need to return either Yes or No between A and B( if the dates between B and C is between 2 working days ).... =IF(D2="","",IF(DATEDIF(B2,C2,"D")>2,"No", "Yes")).....
2. Column J need COUNT the number of days between E and I ........=(NETWORKDAYS(E2,I2))
3. Column G to return either YES or NO if the dates in E AND f IS within 3 working days .......=IF(G2="","",IF(DATEDIF(E2,F2,"D")>3,"No", "Yes")

Cases where the columns are empty, it should return empty, i am working with 500 rows and some dates will be missing which is normal but i want those missing dates to be empty when am draging the formulars down.


Thanks all in advance for your help

[dilipandey]

Hi Austine,

Welcome to the forum.
Suggest you to change the thread title to reflect the query you are asking - at least you can mention formula name in the title
see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey
<click on below * if this helps>