Multiple if calculation

[work_related]

Please. Plus someone help with the following formula

Date: 21 March
Today’s date: 19 March
Ccy: Usd

Date: 28 March
Today’s date: 19 March
Ccy: eur

Need the formula calculation to say if it is eus and two day prior to due date to say yes and if more than two day to say no and if it is usd to say yes if one day prior and no if more than one day.

Thanks

[Special-K]

Try

=AND(A2 < A1, A2+IF(A3="EUR",2,1)=A1,"Yes","No")

with your data in A1 A2 A3

[work_related]

Try

=AND(A2 < A1, A2+IF(A3="EUR",2,1)=A1,"Yes","No")

with your data in A1 A2 A3

I tried but seemed no luck.

If I had data as follows:

21/03/19. 19/03/19. Usd
28/03/19. 19/03/19. Eur

I want it to flag up two days prior to today date for eur and one day for usd.

[Special-K]

1. Oops! Dunno why I typed that formula.
This works

=IF(AND(A2<=A1,A2+IF(A3="EUR",2,1)=A1),"Yes","No")

This will flag 2 days before for EUR and on todays date
or 1 day before for USD and on todays date

2. Whoah! Hold on
Now we're both making mistakes.

In your intial description you said "and two day prior to due date"
Now youve just said "to flag up two days prior to today date"

[work_related]

1. Oops! Dunno why I typed that formula.
This works

=IF(AND(A2<=A1,A2+IF(A3="EUR",2,1)=A1),"Yes","No")

This will flag 2 days before for EUR and on todays date
or 1 day before for USD and on todays date

2. Whoah! Hold on
Now we're both making mistakes.

In your intial description you said "and two day prior to due date"
Now youve just said "to flag up two days prior to today date"

Sorry for confusion. Yes I want it flag up two days or less for eur and one day or less for usd.

[Special-K]

Another attempt, this looks better

=IF(A2+IF(A3="EUR",2,1)>=A1,"Yes","No")

[work_related]

1. Oops! Dunno why I typed that formula.
This works

=IF(AND(A2<=A1,A2+IF(A3="EUR",2,1)=A1),"Yes","No")

This will flag 2 days before for EUR and on todays date
or 1 day before for USD and on todays date

2. Whoah! Hold on
Now we're both making mistakes.

In your intial description you said "and two day prior to due date"
Now youve just said "to flag up two days prior to today date"

Thanks for this. I think this might work initially checking.

Will plug the numbers in tomorrow and double check.