Y or N depending on date and age criteria

[mickjjuk]

Hi

I have a spreadsheet calculating if a child is eligible to receive funding. (ie, all children aged 3 or 4)

In Col A I have DOB's , in Col B I have the formula =DATEDIF(A1,TODAY(),"y") and in Col C I have the formula =IF(B1>2,"Y","N")

However I need the result in Col C to take into account the following criteria:

on TODAYS date or whenever the spreadsheet is open.

Funding is only available from 1/9(1st Sept) this year following a chids 3rd birthday if the child was born between 1/4 and 31/8

for example: if a child was born on 09/04/08 then today he would not recieve funding, but would from 1/9 this year.

or

Funding is only available from 1/1 (1st Jan) this year following a chids 3rd birthday if the child was born between 1/9 and 31/12

or

Funding is only available from 1/4 (1st April) this year following a chids 3rd birthday if the child was born between 1/1 and 31/3

I hope the above is a clear enough explanation.

Can anyone help please

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.