Hi
Need some help building a simple formula.
I would like A1 to be populated with the name of the person when it's 3 weeks before their birthday, I've created a table array called Birthday, see below
[TABLE="width: 341"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Birthday[/TD]
[/TR]
[TR]
[TD]Bert Smith[/TD]
[TD="align: right"]09-Jun[/TD]
[/TR]
[TR]
[TD]Roger Rooster[/TD]
[TD="align: right"]31-Jan[/TD]
[/TR]
[TR]
[TD]Pauline Parrott[/TD]
[TD="align: right"]12-Feb[/TD]
[/TR]
</tbody>[/TABLE]
Need some help building a simple formula.
I would like A1 to be populated with the name of the person when it's 3 weeks before their birthday, I've created a table array called Birthday, see below
[TABLE="width: 341"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Birthday[/TD]
[/TR]
[TR]
[TD]Bert Smith[/TD]
[TD="align: right"]09-Jun[/TD]
[/TR]
[TR]
[TD]Roger Rooster[/TD]
[TD="align: right"]31-Jan[/TD]
[/TR]
[TR]
[TD]Pauline Parrott[/TD]
[TD="align: right"]12-Feb[/TD]
[/TR]
</tbody>[/TABLE]