lundi 21 septembre 2015

Find fourth Thursday each month and if NASDAQ closed that day, take next day

I am working in Excel where I need to find the fourth Thursday in each month but if on that day NASDAQ is closed take the day after. I have this formula for each fourth Thursday:

=DATE(YEAR(A2),MONTH(A2),CHOOSE(WEEKDAY(DATE(YEAR(A2),MONTH(A2),1)),26,25,24,23,22,28,27))  

but I am not be to get the next business day where the fourth Thursday is any one of:

01-Jan-14
20-Jan-14
17-Feb-14
18-Apr-14
26-May-14
03-Jul-14
04-Jul-14
01-Sep-14
27-Nov-14
28-Nov-14
24-Dec-14
25-Dec-14

Aucun commentaire:

Enregistrer un commentaire