trouble with an if statement

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

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

 

[jbp9844]

Try changing the "d' to "d", that seems to work!

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

 

[Frank Kabel]

Hi
try the following:
=IF(E8="","",NETWORKDAYS(D8,E8))

 

[mprokop]

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?

 

[Frank Kabel]

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?

 

[mprokop]

how do I use network days utilizing the current date on the form

in cell G5? IE Days outstanding = today less date submitted

 

[Frank Kabel]

Hi
in which cells do you store these other dates?

 

[mprokop]

=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

 

[Frank Kabel]

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

 

[mprokop]

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(

 

[Frank Kabel]

Hi
you may have to install the ANALYSIS Toolpak add-in (goto 'Tools -
Add-in manager' and check the Analysis Toolpak add-in)

 

[mprokop]

Frank you are a god! It worked, but I added in and it worked!!!

Thank you, amazing!!!


I really really appreciate your effort