Why not using the built in date validation, allowdate, between start date
=A1 and end date =A2
or do you want something else?
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"Gos-C" wrote in
message ...
Hi,
I am trying to enter a formula in the Data Validation settings so that
only days *between* Start Date DAY(A1) and *End Date DAY(A2)* if A2 is
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 spreadsheet
cells, but not in the Data Validation settings:
=IF(ISBLANK(A2),DAY(A1),DAY(A2))
Any help, please?
Thank you,
Gos-C
--
Gos-C
------------------------------------------------------------------------
Gos-C's Profile:
http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=537032