Dave,

I had given this If statment , problem is if i give this if statement i
have another worksheet with the following formula

=SUMPRODUCT((MONTH('sheet2'!A9:A500)=1)*('sheet2'! K9:K500))

formula returns #Value error if i put if statement as you gave , If i
remove that IF statement , formula works perfectly ....

how to rectify this problem ?

thank you
jay
Dave Peterson wrote:
=if(sheet2!a1="","",sheet2!a1)



Jay wrote:

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

--

Dave Peterson