LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 40
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Copying Sheet bg19299 Excel Discussion (Misc queries) 3 July 31st 06 02:20 PM
Date formula that adds 7 days to a cell when sheet is copied dkent Excel Worksheet Functions 1 April 3rd 06 03:59 PM
copying sheet references that refer to a cell in the preceding she GBT Excel Worksheet Functions 1 March 24th 06 07:51 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"