How can I add in the MS Excel if one cell contains date entry and other contains number. How can I add year?

Answer 1

It goes like this
If your cell with date is A1, and your cell with year number is A2, then in B1, paste this
=DATE( A2, MONTH( A1), DAY( A1))

This will generates the date of the same date of cell A1 but for the year of A2

mail me any further questions related in Y! Answers

Enjoy my profile, I am the VBAXLMan

Answer 2

You can add numbers to dates. Now()+1 = tommorow, Now()+7 = a week from now. For year use date(2007,1,1) for 2007 Jan 1st.
Read the documentation.