Date Formula

[mykaltx]

Hello,

I am trying to have Cell A1 Ref a date that material came in. Then I am haveing the date in Cell A2 Ref a date that shows Now or Today. Then in Cell A3 I want it to show the days that have passed.
The problem is when Cell A1 has no date in it the cell in Cell A3 shows the date for Now or Today in numeric ref. I do not want anything to show. I want Cell A3 to stay blank if any part of the formula is not there.
If anyone has information they can email me at [email protected]

[mudraker]

you will need to use an if statement

example for cell a3

=if(or(a1="",a2=""),"",your formula here)

[mykaltx]

This is what I have been looking for. It will caculate the number of days that something is late. If nothing is in there it is blank.