Hello,

I am trying to create a column on my excel tracker that will give me the last date due before something is late. For example, I have Report A which is due to me 30 days before my suspense date, but Report B is due to me 60 days prior. Is there a way to make a formula that if Column A has the suspense date and Column B has the report type, Column C will calculate the date due based off the above conditions? Thanks in advance for any help.

=IF(B1="Report A",A1-30,A1-60)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History