Hi,
sounds like a format problem, right click on the mouse, cell format, date,
choose the desired format

"Amin" wrote:

hi i have two sheets one is inventory the other is summary with the same
style and clumn headings.
now i want the date of the summary sheet to record the dates put in the
inventory column but when i use the formula i get 1900 year, i suppose becos
i yet dont have dates but is there a better way of doing this thing. thanks