mercredi 11 novembre 2015

Excel 2013 Formula - Leave blank entries, if field has date, insert text

Good Afternoon, I have a columns of 200+ entries from A-1 to column AF-1. On the last two columns, I want to set a reminder if there is a date field entered on the left, and the words "Past Due" on the far right column.

I've tried researching this formula by using "IF" commands. The formulas below work in my spreadsheet: =IF(AE10<TODAY(),"PAST DUE","") -OR- =IF(AE14"<"(TODAY()+7),"PAST DUE","")

I don't want to setup fictitious dates of 1/1/2050 in order for the right column to be blank. But I can if I have to.

Some rows do not have follow-up dates so they are blank. I would like the blank cells to the left column, remain blank on the right column.

If there is a date, I would like the phrase "Past Due" to show in the right column. I will then use conditional formatting to highlight those cells with "Due" text in them.

I have tried: =IF= () OR (working formula) =IF(BLANK(AE10)... =IF(AE10="","",=DATEDIF(AE10,TODAY(),"d"))

I hope this makes sense to someone. Thank you for your time.

Aucun commentaire:

Enregistrer un commentaire