#1 I want to enter the (NOW) function in A1 and next to it enter a
number. (a diabetes blood sugar measurement)

I want to do this every day with tomorrws date being in A2 and the
number in B2. My problem is that each day A1 changes to the current
NOW........how do I get it to show yesterdays date?

#2. I have been (mis) using the NOW function for a few days, now
everytime I hit the functions button that's the only function I can
get. How can I tell it that I also want to use other functions as
well?

Thanks