Returns the number of days in the pipeline

[jbp]

Review Date Approved date PipeLine
1-Jun-04 16

I need a formula that tells me how much days is between
the review date and approved date and it will continously
change everyday.

Thanks

JBP

 

[Frank Kabel]

Hi
simply subtract them like
=A1-B1
and format this resulting cell as number