Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calculating Number Of Days between two dates in FORMULA

Hi

I have two dates like 'start date' and 'end date ' .

And im calculating 'Number Of Difference Days' between these dates in formula .

If i dont have 'end date' value then im getting some NEGATIVE VALUES in 'Number Of Difference Days' column

If the two dates are same then im getting zero in 'Number Of Difference Days' column

If 'end date' is greater than ;start date' then im getting some positive value in 'Number Of Difference Days' column

My question is , if i get NEGATIVE VALUES in 'Number Of Difference Days' column then how can i make it as ZERO .

pls let me know

Regards

Suresh

Not what you were looking for? View more on this topic or Ask a question