Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional End Date in Data Validation Settings
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Data Validation possible in Excel 2003? | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |