Conditional Formatting Dates

[staci0604]

I am looking to do a conditional formatting formula as follows:

In one cell someone can write a date based on that date it will auto populate 4 other boxes.

If a person types in a date 01/01/16 through 01/31/2016 into a cell the other four cells boxes will become:

[TABLE="width: 500"]
<tbody>[TR]
[TD]01/25/16[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Jan[/TD]
[TD]2015[/TD]
[TD]Dec[/TD]
[TD]2015[/TD]
[/TR]
</tbody>[/TABLE]

If a person types in a date 02/01/16 through 02/29/16 the other four cells will become:
[TABLE="width: 500"]
<tbody>[TR]
[TD]2/4/16[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Feb[/TD]
[TD]2015[/TD]
[TD]Jan[/TD]
[TD]2016[/TD]
[/TR]
</tbody>[/TABLE]

And so on for the months of the dates to follow, can anyone think of some formulas that could make this work, I’d really appreciate it, thank you!

 

[Andrew Poulsom]

Try eg:

=TEXT(A1,"mmm")
=YEAR(A1)-1
=TEXT(EOMONTH(A1,-1),"mmm")
=TEXT(EOMONTH(A1,-1),"yyyy")+0