Date calculations resulting in blank

[dianem]

I'm using an IF statement to fill a series of dates. I have a start date field and an end date field as well as day 1, day 2, day 3, etc fields. Some events last three days and some last five or more. I've used the following formula in day 2, day 3, etc fields:

IF(end date<=day 1,day 1 +1,"")

The result of the calculation of course is a date.

I want the "" to mean leave the field blank. It's putting in a ? when it runs out of dates. Any help would be most appreciated.

Diane

[-Queue-]

Use TextToDate("") to avoid the question mark.

[dianem]

Perfect...I knew there had to be a simple solution.

Diane