Specific dates in IF formula

Hello there,

For the spreadsheet I use for my Financial Trading system, I've created an alert system - i.e. it has several formulas that tell me if my figures are odd, and it reminds me if it's a monday (significant).

What I need now, is an alert for a specific day in a specific month - I need a formula that shows the cell value as "NFP" every first friday of the month and "Expiry" every third friday of the month.

I've tried searching the internet but couldn't get the correct search terms, so apologies if something like this has already been answered.

Thank you,

Daniel

Hi daddylonglegs,

Thanks so much for your response, that formula works perfectly 😄

I appreciate your time. No more overdrafts due to NFP or Expiry it seems!

Many thanks,

Daniel