Confusion between NOW and TODAY
Posted by Shakara on February 23, 2001 7:02 AM
In a checkbook formula, I was instructed to subtract the date of checks from the current date
(current date formatted with =TODAY() function) to get the number of days the checkbook was in use - or number of days since checkbook was started.
In another exercise an Invoice date was formatted with the =NOW() function. I then had to determine the number of days since the invoice was issued by using the =TODAY() formula minus the original invoice date.
These problems are very similar. Is there a rule of thumb to determine HOW and WHEN to use NOW and TODAY formulas? It's very confusing.