Assigning a number to a date within a date range

[jimbogarner]

Hi,

I am trying to find a formula that assigns a number to a date depending on where it falls in a date range, for example;

In the range October-20 > September-21 - the month of December-20 would be month 3... in the range December-20 > November-21 the month of December-20 would be month 1...

Is this feasible?

Thanks,

James

 

[Alex Blakenburg]

Try this:-

20210506 Count Months.xlsx
	A	B	C	D	E
1	Start Period	End Period	Month	Month No
2	Oct-20	Sep-21	Dec-20	3
3
Sheet1

Cell Formulas
Range	Formula
D2	D2	=DATEDIF(A2,C2,"m")+1

 

[jimbogarner]

=DATEDIF(A2,C2,"m")+1

Thanks, this seems to just return Jan-00 everytime, am I doing something totally wrong?

Thanks,

James

 

[Fluff]

Change the cell format to General.