Hi

I have a relatively large spreadsheet that is being used to calculate due dates for requests for information, some need to be paid for and others don't.

I have 3 columns of dates

A is date request was received
L is date payment was received (if one is needed)
N is due date

A and N will always have dates in them and L will only have a date on if we have charged.

What I am looking to do is calculate 40 calendar days between A and N but for excel to recognise that if there is a date in L that it switches the calculation to 40 days between L and N

Hopefully this makes sense??

Any advice gratefully received!!

Thanks