WORKDAYS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

workdays - 15 Mar 2006 16:20 GMT

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?

Reply to this Message

SVC - 15 Mar 2006 16:50 GMT

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.

> 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?

Reply to this Message

workdays - 17 Mar 2006 20:25 GMT

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 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
[quoted text clipped - 5 lines]
> > 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?

Reply to this Message

SVC - 17 Mar 2006 21:04 GMT

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).

> Not understanding that....let me try this.
>
[quoted text clipped - 13 lines]
> > > 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?

Reply to this Message

workdays - 17 Mar 2006 22:11 GMT

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?

> 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
[quoted text clipped - 19 lines]
> > > > 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?

Reply to this Message