Date formula

kborrell

I'm trying to write a column formula to give a response for a calendar difference. In one column I have a start date. In another column I have the end date, in a third column I have actual delivery date. I can write a formula that says if date 1 is > date 2 it would be "late". I can also write a formula for early, on time and on target. What I would like to do is write a column function formula that would populate the cells in the column as the dates are entered and not have to do each row at a time. Can anyone help me with this?

Matt Johnson

Hi @kborrell

Can you please send the formula you are using?

Thanks,

kborrell

=IF([Delivery Date]@row < [Projected End Date]@row, "Early")

I want it to also calculate "late", "on time" and "on target"

kborrell

=IF([Delivery Date]@row = [Projected End Date]@row, "On Time")

=IF([Delivery Date]@row = [Projected End Date]@row, "Late")

kborrell

Any suggestions?