Hello,

I need help with a formula that does:

I have in col A all calendar dates in 2017, in col B I need a formula that grabs a number (say $10) from another sheet only if the date is a Thursday on a biweekly basis.

for example:
Tuesday 24-Jan-17
Wednesday25-Jan-17
Thursday 26-Jan-17 $10.00
Friday 27-Jan-17
Saturday 28-Jan-17
Sunday 29-Jan-17
Monday 30-Jan-17
Tuesday 31-Jan-17
Wednesday01-Feb-17
Thursday 02-Feb-17
Friday 03-Feb-17
Saturday 04-Feb-17
Sunday 05-Feb-17
Monday 06-Feb-17
Tuesday 07-Feb-17
Wednesday08-Feb-17
Thursday 09-Feb-17 $10.00
Friday 10-Feb-17
Saturday 11-Feb-17
Sunday 12-Feb-17
Monday 13-Feb-17
Tuesday 14-Feb-17
Wednesday15-Feb-17
Thursday 16-Feb-17

I'm ok with the "Thursday" part, I use =if(text(A2,"dddd")="Thursday"...but I don't know how to get the biweekly one work.

thanks so much!
Lynn