Using IF and ISBLANK to calculate dates

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

Good day,

Use the following for Row#1 of your data

Please Login or Register  to view this content.

Show your appreciation - Click the star icon if this post has been helpful

Thanks for this

I have input the formula and it has come up with a due date but how can I get it to add 40 days onto the calculation?

So nearly there ... The due date is coming up with 0-jan-00 !!

Am I being silly?

Example.xls

I am trying to get it to work for me and it won't ... hmmm

I have attached what I am trying to do and input the formula in, but in N2 it is still coming up with 00-Jan-00.

Any suggestions gratefully received!

Good day,

This is because of 'circular references' in Column N.

On re-reading all threads, I think I have now understood your requirment. Please refer attachment and let me know if this is what you're looking for.

Show your appreciation - Click the star icon if this post has been helpful

have had a look and fingers crossed it works!!

Thank you both :-D