G

#### Guest

spreadsheet is =Now()-33 (to Sat May 5, 2007) the HLookup formula in column

D, rows 5 - 24, of the CPH Master spreadsheet does not work (pulls in data

from wrong column). However, if the formula in B4 on the Monthly Expense is

=Now()-32 (to Sun, May 6, 2007) the HLookup formula in Column D, rows 5 - 24,

of the CPH Master does work.

Example formula in row 5 of the CPH Master is: =HLOOKUP('Monthly

Expense'!$B$4,'Monthly Expense'!$C$4:$P$22,3,TRUE)*'CPH Master'!$B$28

If today's date is June 8, 2007 and formula in B4 on Monthly Expense

spreadsheet is =Now()-34 (to Sat May 5, 2007) the HLookup formula in column

D, rows 5 - 24, of the CPH Master spreadsheet does not work (again, pulls in

data from wrong column in look up table). However, if the formula in B4 on

the Monthly Expense is =Now()-33 (to Sun, May 6, 2007) the HLookup formula in

Column D, rows 5 - 24, of the CPH Master does work.

This report has run for a couple of months for a variety of sites (all using

the same template) and this is the first time this problem was noticed. It

appears to have something to do with the dates and not the formula. The

effectiveness of the formula in both described incidents changes with the

date, not the formula.

Any ideas?