Previous Topic Next Topic

01/26/1900 DATES

Closed
NENE61 - May 29, 2009 at 02:28 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 29, 2009 at 08:43 AM
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 responses

Answer 1 / 3
yuyuman Posts 9 Registration date Sunday February 24, 2008 Status Member Last seen June 1, 2009 2
May 29, 2009 at 04:32 AM
Hello there, due to the problem you are having.. is there a way you send us the formula you are using please?
0
nene61
May 29, 2009 at 07:29 AM
My formula is A1(date entered by user) + 29 = the 30th day from the file date in cellA2. If there nothing in the blank ill get that 1/26.1900 error.
0
NENE61
May 29, 2009 at 08:17 AM
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.
0
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165 > nene61
May 29, 2009 at 08:23 AM
Change the formula in Cell A2 with this ......

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

Please confirm if it works !!!!!

The problem is only because you have formatted the cell as Date format but using above formula it will work fine ......

0
NENE61 > mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010
May 29, 2009 at 08:31 AM
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.
0
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165 > NENE61
May 29, 2009 at 08:36 AM
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)


0
Answer 2 / 3
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
May 29, 2009 at 05:26 AM
Just change the cell format as its taking your formula as date .... or you can make change in your formula like if(true,formula,"")


0
Answer 3 / 3
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
May 29, 2009 at 07:49 AM
Just in Cell A2 Clear All by Edit > Clear > All and see what happened

0

Similar discussions

forgot security code of my nokia c2 01
cherrybiscocho -
Ambucias -

1 response
Using Vlookup to return insted of 00/01/1900
Tom9o -
tom9o -

2 responses
Cannot Open 192.168.1.1 with TP-link
Gsimar -
kureka -

9 responses
nokia c2-01 unlock security code
jayaugustine -
1515615 -

3 responses
Forgot security code Nokia c2-01
Davidnzomba -
HelpiOS -

1 response