WORKDAYS

[Guest]

HOW DO YOU GET THE CELL THAT HAS A FORMULA FOR CALCULATING A DATE TO REMAIN
BLANK UNTIL ANOTHER CELL IS FILLED IN WITH A DATE. RIGHT NOW THE WORKSHEET
SHOWS WITH DATES FROM 1900 BECAUSE EXCEL ASSUMES THAT I AM CALCULATING FROM
01-01-1900. THIS WILL BE CONFUSING FOR THE USERS...CAN YOU HELP?

 

[Guest]

Assuming that the cell that is to have the date enter is A1, in the cell
containing the formula enter =If(A1="","",FORMULA), where FORMULA is the
formula use to calculate the date. Modify the above formula to reflect the
actual cell and the actual formula.

 

[Guest]

Not understanding that....let me try this.

For example, the cell that will remain blank until a date is entered is A1
(there is no formula for that cell). Cell A2 has the formula =SUM(B7+179).
This results in 06/27/1900 displaying in cell A2, with no date in A1. How do
I stop excel from populating these 1900 dates...I would like it to be blank
until a date is entered in A1.

 

[Guest]

Assuming that A1 is empty (no formula, no data entered manually), A2 has the
formula =SUM(B7+179), and cell B7 may or may not have anything to do with
cell A1, modify cell A2 to read =IF(A1="","",SUM(B7+179)). As long as cell
A1 is blank, cell A2 will be blank; otherwise, cell A2 will calculate
SUM(B7+179).

 

[Guest]

That worked, thank you. Although, it seems like an awful lot of work to go
through just so the 1900 dates don't show up. I've got lots of formulas I
will have to apply that to...I take it there's no easier way?