Insert Current Date when cell is empty??

  • Thread starter Dazed&confused!
  • Start date
D

Dazed&confused!

HI

Apologies for this - I just seem to have left my brain at home today.

Essentially I'm calculating the time difference in hours between IssueLogged
and IssueClosed - this bit I have solved ...
=int(IssueClosed-IssueLogged)*24) ...., but the second part I need is if
IssueClosed is empty, get Excel use the current date and use this to show how
long it has been since the Issue was logged.

any/all help appreciated!
D
 
D

Dazed&confused!

Thanks for this - it didn't quiet work tho. I put in date of 05/01/2007
07:00 (5th Jan 07, 7am) and left the IssueClosed cell empty and the formula
came back with value of 51. I checked formatting of the columns etc and
can't see anything wrong with them. The formula returned the expected result
when I put in a date to the IssueClosed cell. Should I force an entry into
the IssueClosed cell of 0??
 
J

JE McGimpsey

Check the formula again. When I put 5 Jan 2007 07:00 in IssueLogged and
leave IssueClosed blank, the formula returns 775, which is correct.
 
Top