Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Copying Sheet | Excel Discussion (Misc queries) | |||
Date formula that adds 7 days to a cell when sheet is copied | Excel Worksheet Functions | |||
copying sheet references that refer to a cell in the preceding she | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions |