#### gleichmang

##### New Member

- Joined
- Dec 28, 2011

- Messages
- 13

This formula recalculates the date based off a value in column P

=IF(OR(P16="A - Svcbl(w/o Qual)",P16=""),(AM16+450),(AM16+90))

This formula determines the amount of days between today and the new date

=ABS(AN16-TODAY())

This formula enters a value based on the above calculation

=IF(AO16<90,"CURRENT","OVERDUE")

How can I combine these into a single cell in column AN?