Using IF(AND syntax

[Harrytheb]

Greetings, I cannot seem to work out what my syntax error is in the following formula:

IF(B1="","",IF(AND(B1<A1,B1>A1-90),A1+360,B1+360))

Column A refers to a date something is due, column B the date it was completed.
The new due date is the calculation that I am trying to formulate.

Can anyone help? Grateful for any assistance as always!

Rgds
Harry

[sandy666]

Syntax is ok, what about logic I don't know without example.xlsx file.

EDIT: and with good description of course. In example should be: What you have and what you want to achieve

[Harrytheb]

Kinda like this

Class returns
A. B
Due Completed
10 Jan 2017 10 Dec 2016
(New due date formula)

[sandy666]

Result should be ?

[Harrytheb]

A2 is the result, either A1 a year later or B1 a year later, if that makes sense?

[sandy666]

I am asking about result of your formula....

I got (short date) 05/01/2018 or (long date) 05 January 2018
Is it correct?

[sandy666]

The best way is:

Attach a sample workbook. (Not a picture!)
Make sure there is just enough data to demonstrate your need. Include a BEFORE (original) sheet and an AFTER (required output) sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary. Remember, it should reflect original structure of your data.
Remember to desensitize the data.
Note:

• Please do not attach password protected workbooks/worksheets
• Please do not attach file(s) from exterior servers
• Please do not attach file(s) with enabled any Workbook Open/Autorun macros!

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

About 20 rows of data, mark wrong result as yellow

[Harrytheb]

That is the right result, a cross check would be to enter today's date and the result would be 31 Jan 18?

[sandy666]

Rather 30 January 2018
If you want 31 January 2018 change 360 to 361 (with your default formula)

[Harrytheb]

Tried formula on a blank workbook and it works for me too. Thanks for confirming the syntax! Rgds Harry

[sandy666]

You are welcome, thanks for the feedback