If conditions

[gerson02]

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.

 

[jtakw]

Hi,

Please explain what you are trying to calculate, This is all you have told us so far:

A1 = Start Date
B1 = Completed Date
C1 = Result you want, 1 or 0
and calculate within a month until 4/30 ???

 

[gerson02]

Sorry i can't show you a screenshot because I'm using mobile. Below is the sample hope you get it..
"If the date completes within the month (4/30/2018), put 1 otherwise 0."

Start date Completion date Monthly
4/2/2018 4/11/2018 ??? must be 1
4/10/2018 5/1/2018 ??? must be 0
4/8/2018 4/2/2018 ??? must be 0

 

[JackDanIce]

Try:

=--(AND ( B1 > A1,B1 < Date(2018,5,1)))

(without the spaces)<date(2018,5,1)))[ code]<="" html=""></date(2018,5,1)))[>

 

[jtakw]

Ok,

Your 3rd sample is incorrect?

Book1
	A	B	C
1	Start Date	Completion Date	Within Same Month
2	4/2/2018	4/11/2018	1
3	4/10/2018	5/1/2018	0
4	4/8/2018	4/2/2018	?????????
Sheet235

Cell Formulas
Range	Formula
C2	=--AND(MONTH(A2)=MONTH(B2),YEAR(A2)=YEAR(B2))

 

[Fluff]

Hi & welcome to MrExcel.
Is this what you want

Excel 2013 32 bit
	A	B	C
1	02/04/2018	11/04/2018	1
2	10/04/2018	01/05/2018	0
3	08/04/2018	02/04/2019	0
Sheet3

Cell Formulas
Range	Formula
C1	=--(EOMONTH(A1,0)=EOMONTH(B1,0))

 

[gerson02]

Thank you so much appreciate your replies i will try it later... Thank you again

 

[gerson02]

thank you guys, it works

 

[Fluff]

Glad we could help & thanks for the feedback

 

[jtakw]

You're welcome.