Using which function to calculatiing 2 set of numbers of days from 3 dates

S

StephenL

I'm using this formula to calculate the days taken to release P/O afte
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/
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/
date)left me with the number "38795" in I column.
How do I over come it.

Stephen
Singapor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If C2 is Sunday how do I make D 2 to the next day of the week 2
data from 1 sheet to the next 6
Interest Calculations 6
Counting no of days from a list of running dates for a 12 month pe 2
Formula to display Count of Days in given month, using list of Startand End Dates 1
to find number of days between 2 dates using vba code in excel 3
1-2-3 @ function to Excel Assistance 8
How to calculate the number of days between 2 dates 3

Top