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