Nested IF to return text string based on certain conditions

Hi Guys,

I hope you can help, please.

I have attached the excel file, but I will also explain.

> The assess date and the actual date is always the first day in the month.

> In every scenario, where the assess date is prior to the actual date, it needs to return error

> One exception to this, is when the assess date is exactly one month prior to the actual date, it needs to return "staging"

> Where the assess date and the actual date are equal, or the assess date always exceeds the actual date, it needs to return "subsequent"

I have kindly received help on here previously, but I could not get the formula to work based on the fact that both assess and actual are now the first day in the month.

Any help greatly appreciated.

Thanks!

You may try this nested IF formula (see attachment)

=IF(SUM(D4-C4)>30,"Error",IF(OR(SUM(D4-C4)=31,SUM(D4-C4)=30,SUM(D4-C4)=28,SUM(D4-C4)=29),"Staging",IF(SUM(D4-C4)<1,"Subsequent")))

Remember to drag down to last entry

Guys! thanks so much. Much appreciated.