Please how can I make Excel 2013 to insert date accordingly to data interring current date instead of 08/8/1900 example in Column E, in Column J I entered the date manually, if not in that column J if I begin to type date excel will automatically make it 1900 regardless the fact that the above cells have 2013 . Please download the excel sample file to see what I mean.
Secondly how can I make excel to automatically insert date in a cell once I inter data by (row)in a cell I have a column with date function but each time I inter data in a cell I have to go to the cell in that column and inter manually the date, Please download the Excel file to understand better,thanks for help in advance really.
2.xlsx