Calculate number of days from in Locationfrom Entry

[Thomas Kuriakose]

Respected Sirs,

Kindly check and correct me for the correct function to be used to arrive at the following days calculation for materials received in location to materials issued out of location -

1. No. of Days in Location from SRD
2. No. of Days in Location from Entry Date
3. No. of Days in Receipt Date to Issue Date
4. No. of Days Since Issue Date

I have summarized the values in the pivot, kindly let me know whether the average values will be the correct selection if the data has more materials.

Thank you very much,

with regards,
thomas

 

[Villalobos]

Hi,

I would have one remark: take care with the blank cells (in date columns) in the formulas.

I attached my proposal.

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for the correction and revised proposal.

Much appreciated.

with regards,
thomas