Date Formula

[jjramirez85]

I have a workbook where I enter a specific date such as today into an input cell, and I want the formula to output if the record date is one of the following "Previous", "Current" or "Future".

If I input 6/19/18 into my input cell then ---

If before the 1st of the month of June then "Previous"
If equal to or greater than the 1st day of the month but less than the input date then "Current"
If greater than input date than "Future"

This is what I attempted, but future is based off end of month---


=IF(K2<EOMONTH('by Sites - Current mo'!$B$2,-1)+1,"Previous",IF(K2>EOMONTH('by Sites - Current mo'!$B$2,0),"Future","Current"))

 

[mse330]

How about this ?

Book1
	A	B
1	Input Date
2	19-Jun-18	Current
Sheet1

Cell Formulas
Range	Formula
B2	=IF(A2<=EOMONTH(TODAY(),-1),"Previous",IF(A2>TODAY(),"Future","Current"))