If + adding date values in many cells

[Nalim]

Hello, I'm struggling with this problem for an hours. Banging my head to the wall

In one column I have values 1,2,3 marking the years. Column N
In second I have a certain date (mm/dd/yyyy format). Column O

I want to have in column P added new date that will be one year after the certain date in column O if a certain condition is meet.

So I am using if function and tried with 3 different methods and formulas

=IF(N3>1,SUM(O3+365),0)
=IF(N3>1,O3+365,0)
=IF(N3>1,DATE(YEAR(O3)+1,MONTH(O3),DAY(O3)),0)

On the first cell it gives me an exact value, but when I click to drag over next cells - it gives me the same values like in the one in the first cell. I even tried naming the date range and still when I drag over to populate the cells bellow it stays the same.

Strange is that once I go to the other wanted cell, the formula shows correct values =IF(N134>1,SUM(O134+365),0) but the result is the one like from the start.
What is even more stranger is that when I click on some of those incorrect cells, and do not change the formula and press enter then it gives me a proper result.

When I'm dragging I even clicked all the possible options, fill, copy etc... no results.

 

[JLGWhiz]

maybe

=IF([COLOR=#B22222]$N$3[/COLOR]>1,O3+365,0)

 

[Tetra201]

... Strange is that once I go to the other wanted cell, the formula shows correct values =IF(N134>1,SUM(O134+365),0) but the result is the one like from the start.
What is even more stranger is that when I click on some of those incorrect cells, and do not change the formula and press enter then it gives me a proper result.

Make sure your Formulas --> Calculation Options are set to 'Automatic'.

 

[Nalim]

Make sure your Formulas --> Calculation Options are set to 'Automatic'.

That was it!!! Great, thanks, it works now perfectly.

 

[Tetra201]

Glad to have been of help.