software

I'm using this formula to calculate the days taken to release P/O after
PR had been release, (PR = purchase requisition):
=IF(H5=0,$H$3-G5,H5-G5)
where cell H5 is the date of PR released date and G5 is the P/O
released date,
H3 is the reference date being today's date and I5 is the result.
My data include a chart to determine the efficiency of purchase dept,
but those columns H that do not have any PR release date,(prior to P/O
date)left me with the number quot;38795quot; in I column.
How do I over come it.

Stephen
Singapore--
StephenL
------------------------------------------------------------------------
StephenL's Profile: www.excelforum.com/member.php...oamp;userid=14512
View this thread: www.excelforum.com/showthread...hreadid=524022
Perhaps this

=IF(G5,IF(H5=0,$H$3,H5)-G5,0)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=524022
Thanks a million, Daddylonglegs.
I got it.--
StephenL
------------------------------------------------------------------------
StephenL's Profile: www.excelforum.com/member.php...oamp;userid=14512
View this thread: www.excelforum.com/showthread...hreadid=524022