If today's date is June 7, 2007 and formula in B4 on Monthly Expense
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?

--
searcherlady