WORKDAYS

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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.
 
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).
 
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?
 
Back
Top