01/26/1900 DATES

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

EXCEL 2003

I have an unknown date to put an input cell A1. I have an formula in A2 to caculate 29days from A1. I don't have the information at this time to put in A1 and it is blank with no data but in A2 instead of being blank or with mm/dd/yyyy it have populated 01/26/1900. How do I get rid of this date without taking out my formula.

3 replies

Posts
9
Registration date
Sunday February 24, 2008
Status
Member
Last seen
June 1, 2009
2
Hello there, due to the problem you are having.. is there a way you send us the formula you are using please?
>
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010

Ok it gave me a true in A2 instead of being blank. I also put a date in A1 and then it gave a false statement. I need it to caculate a date when a date is put into cell A1 and if I don't have a date in cell A1 in need cell A2 show nothing.
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155 > NENE61
This formula is working fine with me, anyway try below formula

=IF(A1="","",A1+29)


But my previous formula should work ....just check it again

=IF(ISBLANK(A1),"",A1+29)


>
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010

Thanks it works.
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155 > NENE61
u welcome but both formula's should work ...... you can use them in other cells as well .....
I tried to do that in A2 but it took away my formula. A2 is the cell I have my formula in to caculate A1(unknown date) + 29 to give me the 30th day from cell A1.
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
Just change the cell format as its taking your formula as date .... or you can make change in your formula like if(true,formula,"")


Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
Just in Cell A2 Clear All by Edit > Clear > All and see what happened