trouble with an if statement

  • Thread starter Thread starter mprokop
  • Start date Start date
M

mprokop

I am trying to have a cell calculate the difference between dates but
also want it to register nothing if one of the date cels is blan
(meaning hasn't been recv'd yet)

what am I missing in this formula

=IF(ISBLANK(E8),"",DATEDIF(D8,E8,"d'))

the two cells to calculate the dates are D8 & E8 but sometimes E8 won'
have information yet so I don't want it to try to calculate th
difference just remain blank

Does anyone know how to complete this correctly?:confused:

It is in the RFI LOG Sheet. Also, is it possible to change it fro
calendar days to work day

Attachment filename: rfi.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45378
 
how do I incorporate the NETWORKDAYS I want to show days outstanding?
Last column in spreadsheet. I tried using the below formula but i
gives me blank?
 
Hi
the formula checks if E8 is empty. If yes it also returns a blank cell.
So what is the exact formula you have used?
 
how do I use network days utilizing the current date on the form

in cell G5? IE Days outstanding = today less date submitted
 
=IF(E8="","",NETWORKDAYS(G5,D8)) and it give me a blank. what I a
trying to achieve is the following logic:

if cell E8 is blank then take the difference between the current dat
in cell G5 from D8.

If E8 is blank then the item has not been received yet and it is # o
work days outstanding. I want to show the number of work day
outstanding and have the cell blank if there is a date in E8.

I am sooo grateful for your help. Please be patient with me
 
I put it in exactly as you have it and it gives me #name

=IF(E8<>"","",NETWORKDAYS(G5,D8))


these are the correct cells I need info from

Does the fact that G5 is formula matter

=TODAY(
 
Hi
you may have to install the ANALYSIS Toolpak add-in (goto 'Tools -
Add-in manager' and check the Analysis Toolpak add-in)
 
Frank you are a god! It worked, but I added in and it worked!!!

Thank you, amazing!!!


I really really appreciate your effort
 
Back
Top