Hi Team,

I have Facility Code and Billing code for each resident. 

I will have to formulate the "If" function comparing the date and estimated end of stay date.

Then extract the value from the pivoted table for particular Billing code and Facility. Can you please guide me with the formulae for that.

Please see attached reference for expected result.

Thank you.

Regards,

Aye