If then formula help with multiple rules - need help!

[adamant201]

Hi, I would like to create a drawing tracker sheet which shows if items have been issued or are overdue / days remaining. Thanks in advance!

The way I need it to work is...

For column E to calculate an overdue date or days remaining with positive / negative numbers in relation to todays date and column B date IF column D is blank

If column D has a date that means the drawing has been issued and no calculation is required, and therefore column E will show as "issued"

 

[mrshl9898]

Like this?

=IF(D2<>"","Issued",B2-TODAY())

 

[adamant201]

Like this?

=IF(D2<>"","Issued",B2-TODAY())

Great it worked! Thanks!