nested if date comparison and return string

[Mikeyabosbht]

Hi Guys,

Hope you can help.

I need to compare dates between two columns and return various types of text string.

We have an assessment date which can vary and is always based on the first day of the month in a year. This needs to be compared to an earnings period date and the two dates will never coincide

It might not actually have an assessment date and I would like it to return " " or Blank space.

If it falls on the 18th of the same month or subsequent months, I need it to return "Subsequent"

If it falls on the 18th of the prior month to the assessment date, I need it to return "At Staging"

If it falls on the 18th MORE THAN one month prior to the assessment date, I need it to return "Error"

Thanks so much.