Formula to change dates

Hello:

Please refer to attached file.

I have A1 = 2015
I have dates in column N and O for 2015.

I need a formula so that if i change A1 = 2016 then those dates will change the year part to 2016

Let me know if you have any questions.
Thanks.

Hi Allkey:

I got your solution working.
Thanks a lot..................
Riz

Hi Allkey:

I think there is some misunderstanding.
I will have year in Cell A1.
Now need a
Formula in cell N1 which will give N1 as first day of 1st month of year in cell A1.
Formula in cell O1 which will give O1 as 15th day of 1st month of year in cell A1.
Formula in cell N2 which will give N2 as 16th day of 1st month of year in cell A1.
Formula in cell O2 which will give O1 as last day of 1st month of year in cell A1.

Formula in cell N3 which will give N3 as first day of 2nd month of year in cell A1.
Formula in cell O3 which will give O3 as 15th day of 2nd month of year in cell A1.
Formula in cell N4 which will give N4 as 16th day of 2nd month of year in cell A1.
Formula in cell O4 which will give O4 as last day of 2nd month of year in cell A1.

and so on.

Please let me know if you have any questions.
Thanks.

Riz

Try

N1: =DATE($A$1,1,1)
N2: =DATE($A$1,1,16)
N3: =EDATE(N1,1) <- Fill down to N24

O1: =N2-1 <- Fill down to O23
O24: =DATE(A1,12,31)

Hi Guys:

Thanks a lot to all excel expert and seems like all of the above formulas will work for me.
Riz