I am trying to get this formula to work. I need it to look at three different areas in order to return a yes or no. If I change one area I want it to change the yes or no to correspond with the date for that area. I am using information from a seperate sheet in the same workbook. Here is what I have:
=IF((AND(C13=MILESTONES!$A$6,L13=MILESTONES!$D$1,TODAY()<=MILESTONES!$D$5)),"Yes","No")


Any Ideas???