I have to get post date if there would be an holiday including sateray and sunday. the formula should retrivre post date if it is fall in holiday through out the 2013 year. please help

Hi To answer your question we would need to know how your data are arranged but in general this is what you might do ....

You would need to set up a table with each holiday's date e.g.

Col AA Col AB 1 Holiday x Date 2 Holiday y Date 3 Holiday z Date etcThen in a column next to each date you want to evaluate you can have a formula like this

(assuming your dates are in Column F starting in row 1=IF(OR(WEEKDAY(F1)=1,WEEKDAY(F1)=7,ISERROR(VLOOKUP(F1,$BB$1:$BB$20,1,FALSE))=FALSE),"Holiday","")Give this a try or if I've misunderstood please come back with more details.

Ask Your Question

Weekly Poll