D

#### David Lipetz

cell to indicate the current date period.

There are four rows of data, each representing a calendar quarter Q1, Q2,

Q3, and Q4. Each row has a cell which indicates the last transaction date

for that period. In the Q1 row, that date is 03/31/08. In the Q2 row, that

date is 04/25/08 as that is the most current data set loaded. Q3 and Q4 date

cells are blank.

The first part of the formula needs to check if there is data by evaluating

if the date cell is blank. If it is blank, then the result should be a blank

(""). If not blank, proceed below.

The next part of the formula determines which quarter we are in based on

todays date.

In the Q1 row, if current month is equal to 1, 2, or 3, then display the

symbol.

In the Q2 row, if current month is equal to 4, 5, or 6, then display the

symbol.

In the Q3 row, if current month is equal to 7, 8, or 9, then display the

symbol.

In the Q4 row, if current month is equal to 10, 11, or 12, then display the

symbol.

The formula below (for Q1) does not work; it evaluates as volatile.

=IF($C43="","",IF(OR(MONTH(TODAY())=1,MONTH(TODAY())=2,MONTH(TODAY()=3)),"?",""))

$C43 is the last transaction date cell.

How should this formula be written?

Thanks,

David