Solved I have to get post date if there would be an holiday.

January 23, 2013 at 08:23:20
Specs: Windows XP
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

See More: I have to get post date if there would be an holiday.

Report •

#1
January 23, 2013 at 11:59:11
✔ Best Answer
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
etc

Then 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.


Report •
Related Solutions


Ask Question