Updating Dates Format

[cheddarthief]

I have a spreadsheet where cell B4 has the formula to update to the current date "=today()". Column A is Invoice #'s, Column B has the Date Issued, and Column C should calculate using a formula Days Open. In cell C9 I have the formula "=B4-B9". B4 needs to always be a constant value in the formula while B9 would be a variable. So assuming that today's date is the 15th (cell B4) and the date issued in B9 is the 1st of the same month/year, the returned value would be 14. This part works fine. Now, if I want to copy the formula and put it in all the cells in column C, the formula updates the source cells as it moves down each row which is okay for the row values but not for the constant B4. I want the formula to always use cell B4 (today's date) and subtract the variable in column B as it is copied down. How do I do this?

Thanks,
Jim

I've added a copy of the file. Please note the two different tabs at the bottom.

[Pepe Le Mokko]

You could use

=today()-B9

and pull down as needed. Of course the results will be different tomorrow

[cheddarthief]

Duh!!! I'm so dumb. That is so obvious. Thank you!!

[Pepe Le Mokko]

Glad to help, and never mind, we all make mistakes