Place a number in a calendar like spreadsheet, that places a number every second thursday

[umirin]

A B C
[TABLE="class: grid, width: 1338"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Thu 05 Apr[/TD]
[TD]Fri 06 Apr[/TD]
[TD]Sat 07 Apr[/TD]
[TD]Sun 08 Apr[/TD]
[TD]Mon 09 Apr[/TD]
[TD]Tue 10 Apr[/TD]
[TD]Wed 11 Apr[/TD]
[TD]Thu 12 Apr[/TD]
[TD]Fri 13 Apr[/TD]
[TD]Sat 14 Apr[/TD]
[TD]Sun 15 Apr[/TD]
[TD]Mon 16 Apr[/TD]
[TD]Tue 17 Apr[/TD]
[TD]Wed 18 Apr[/TD]
[TD]Thu 19 Apr[/TD]
[TD]Fri 20 Apr[/TD]
[/TR]
[TR]
[TD]Number[/TD]
[TD]100.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]100.00[/TD]
[TD]

[/TD]
[/TR]
</tbody>[/TABLE]


Hi All I need some help please. I would like a formula to go in B2 Cell, a formulai can fill accross the B row that would place the number 100 in every second Thursday as exampled above.

 

[Peter_SSs]

Try
=IF(AND(WEEKDAY(B1)=5,MOD(SUMPRODUCT(--(WEEKDAY($B1:B1)=5)),2)=1),100,"")

 

[mopp1]

or
=IF(MOD(INT(B1)-5,14)=0,100,"")

 

[Peter_SSs]

or
=IF(MOD(INT(B1)-5,14)=0,100,"")

Not exactly sure what the OP's requirements are, but that won't necessarily pick up the 1st, 3rd, 5th etc Thursday in the list. eg If the date list started on 6 April

 

[umirin]

Try
=IF(AND(WEEKDAY(B1)=5,MOD(SUMPRODUCT(--(WEEKDAY($B1:B1)=5)),2)=1),100,"")

Thanks Pete. Exactly what I was after.

 

[Peter_SSs]

Thanks Pete. Exactly what I was after.

You are welcome. Glad to help.