Try using TODAY() rather than NOW() and tell us if this works
You seem to want only the date not date+time
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"searcherlady" wrote in message
...
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