Macro DtRNG as Range, Dt as Range, Multiple Criteria or dates

Originally Posted by jessebranum777

So I would say what

Const "?" = Date1
Const "?" = Date2
Const "?" = Date3
Const "?" = Date4
Const "?" = Date5
Const "?" = Date6

What about format if i do it this way?

Also could i set the Const "?" = "A cell reference in the personal.xls sheet1 like B1 and put the date in the cell then manipulate the format from that point?

I would still like an example of what you mean in order to setup those dates as constants as to what goes in the ? mark area I have no idea.