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.

01/26/1900 DATES
Canon f17 1900 printer driver download - Download - Drivers
Defcon dates - Guide
How to highlight overdue dates in excel ✓ - Excel Forum
Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
Vivatech 2024 dates - Guide

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?

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.

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.

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166 > 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 ......

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.

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166 > 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)

Answer 2 / 3

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
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,"")

Answer 3 / 3

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
May 29, 2009 at 07:49 AM

Just in Cell A2 Clear All by Edit > Clear > All and see what happened

Similar discussions

encryption message several time in chat

blank white page for website

IF statements with dates and criteria

how to convert ounces (oz) to milliliter

using web browser page loads but screen blank

Similar discussions

Subscribe To Our Newsletter!