formula to set a minimum number that can be in a cell

[geospatial]

I am looking to figure out how to set the minimun number a cell can be. I have a spin button that changes the number in a cell up or down depending on the click, but I do not want the number to ever be able to go lower than one.

Right now the formula I have in the cell is =E1-DATE(YEAR(E1),1,0)
E1 is my date field. So right now if someone keeps clicking to go backwards eventually it will try and make it go to 0 which is a NA as there is no date before Jan 1.

 

[Smitty]

There's a minimum value setting for the Spin Button control.