Hi everyone please help me.
I have difficulty in my excel formula.
I have my start date 4/2/2018 (a1) and completed date 4/11/2018 (b1) to calculate within a month which until 4/30, value must be 1 otherwise 0 (c1)
Thank you in advance for you response.