Quote Originally Posted by daddylonglegs View Post
I would include the year, e.g. put 2012 in A1 then try this formula in B3

=IF(ISNUMBER(A3),WORKDAY(A3&LOOKUP("zzz",A$2:A3)&A$1,8),"")

format B3 in required date format then copy down the column

Copy the formula into columns C and D, changing 8 to 10 and 14
Thank you for such a quick reply!! I will try this immediately! Just a quick question though, what do you mean by adding 2012 to A1? Do you mean to format the entire column into a date? haha, sorry, I know this is probably elementary but I am quite hopeless with excel