How to use the current date in a formula

[ferank]

I have an entire column of the number of days accounts have been overdrawn. I have to manually change all the days each time i send this somewhere. Is there a formula i can use that will automatically add the number of days to the current date the spreadsheet is being viewed

Lets say column E has the 1st date account was overdrawn, i want column F to show the number of days the account is overdrawn.

I hope i explained it correctly. Thanks for your time in reading my post, if you have any ideas i would GREATLY appreciate it

 

[Aladin Akyurek]

Lets say column E has the 1st date account was overdrawn, i want column F to show the number of days the account is overdrawn.


In F2 enter:

=TODAY()-E2

Format F2 as General.

Is this what you wanted?

 

[ferank]

You are a lifesaver!!!!

thanks!!!!