Conditional End Date in Data Validation Settings

[Gos-C]

Hi,

I am trying to enter a formula in the Data Validation settings so tha
only days *between* Start Date DAY(A1) and *End Date DAY(A2)* if A2 i
not blank or *End Date DAY(A1)* if A2 is blank are valid.

I can enter the following formula for the End Date in the spreadshee
cells, but not in the Data Validation settings:

=IF(ISBLANK(A2),DAY(A1),DAY(A2))

Any help, please?

Thank you,
Gos-

 

[Peo Sjoblom]

Why not using the built in date validation, allow>date, between start date
=A1 and end date =A2
or do you want something else?

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Gos-C]

That's not valid when A2 is blank.

Gos-C

 

[Peo Sjoblom]

If you deselect "ignore blank" then you can't enter anything

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Gos-C]

If the day in A1 is 24 and the day in A2 in 28, the keyer is allowed to
enter 24, 25, 26, 27 or 28 in cell B5, for example. If the day in A1
is 31 and A2 is blank, then the keyer is allowed to enter 31 and
nothing else.

 

[Peo Sjoblom]

Maybe

=OR(AND(B5>=DAY(A1),B5<=DAY(A2)),AND(B5=DAY(A1),A2=""))

you need to deselect ignore blank

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Gos-C]

Thanks, Peo. That worked!

Gos-C