Bug in excel sheet

[online]

Hi Expert,

I have a excel sheet format in which column D. i want to paste date from other sheet but in increase four year. suppose i paste value 2 may 2011 but it shows in sheet 3 may 2015.
I have attached the file plz help me.

[Bob Phillips]

Looks as though you have the workbook set to the 1904 date system.

Go to Tools>Options>Calculation, and uncheck the box.

[online]

Thanx a lot now it's working............