Dear all,
In the cells B5 and C5(later date) I have two dates (m/d/y)
=C5-MIN(DATE(YEAR(C5),MONTH(C5)-(DAY(C5)< DAY(B5))+{1,0},DAY(B5)*{0,1}))
The formula above calculates the the number of days past the complete months. I kindly ask you to explain me the logic of this formula.
-What does it means {1,0}?Why it was used?
- DAY(B5)*{0,1})) How does it work this multiplication?
- What about C5-Min(date.....................
In the cells B5 and C5(later date) I have two dates (m/d/y)
=C5-MIN(DATE(YEAR(C5),MONTH(C5)-(DAY(C5)< DAY(B5))+{1,0},DAY(B5)*{0,1}))
The formula above calculates the the number of days past the complete months. I kindly ask you to explain me the logic of this formula.
-What does it means {1,0}?Why it was used?
- DAY(B5)*{0,1})) How does it work this multiplication?
- What about C5-Min(date.....................