copying date from one sheet to another work sheet
Hi,
I have Date column on sheet1 and i would like Date Columns to propagate
on other sheets
when i enter this formula on the sheet2
=A1
it displays 01/01/1900 if cell is empty on sheet1
If cell is empty i dont want to display that 01/01/1900 thing on the
other sheet
If sheet1 date column cell is empty and other sheet date column should
be empty no 01/01/1900 thingg.....
how do i rectify this
thank you in advance
regards
Jay
|