Date Formulas with IF ?

[EMY245]

Hello,

I was wondering if someone can help me in creating a formula based on dates.

I need the formula to be able to tell me the month of a set date depending on the day of the month. The criteria is: If the start is after 1st of the month, populate the following month, if not use the current. If the end date is after the 1st use the current month, if not use the prior month. Examples below - i need the formula in 'start month' and 'end month' fields.

I have tried without using the start / end month fields and just using the active months fields with the formula =IF(DAY(B11)>1,DATEDIF(B10,B11,"m")+(DATEDIF(B10,B11,"md")>0)+1,DATEDIF(B10,B11,"m")) but this does not seem to work. The main field i need is the "active months"

Thank you in advance!

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Start Date[/TD]
[TD]4 January 2018[/TD]
[/TR]
[TR]
[TD]End Date[/TD]
[TD]16 April 2018[/TD]
[/TR]
[TR]
[TD]Start Month[/TD]
[TD]February[/TD]
[/TR]
[TR]
[TD]End Month[/TD]
[TD]April[/TD]
[/TR]
[TR]
[TD]Active Months[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

This?

Excel 2010
	A	B
1	Start Date	4-Jan-18
2	End Date	16-Apr-18
3	Start Month	February
4	End Month	April
5	Active Months	3
Sheet5

Cell Formulas
Range	Formula
B3	=TEXT(IF(DAY(B1)>1,EOMONTH(B1,1),B1),"mmmm")
B4	=TEXT(IF(DAY(B2)>1,B2,EOMONTH(B2,-1)),"mmmm")
B5	=1+MONTH(B4&1)-MONTH(B3&1)

=DATEDIF(B1,B2,"m") gives you 3 here but may not under irregular conditions.

 

[EMY245]

Amazing, that works - thank you so much!