How to use the current date in a formula

ferank · Apr 19th, 2002, 01:48 PM

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 · Apr 19th, 2002, 01:53 PM

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 · Apr 19th, 2002, 01:56 PM

You are a lifesaver!!!!

thanks!!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 01:48 PM	#1
ferank New Member Join Date: Apr 2002 Posts: 16	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

Apr 19th, 2002, 01:53 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	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?

Apr 19th, 2002, 01:56 PM	#3
ferank New Member Join Date: Apr 2002 Posts: 16	You are a lifesaver!!!! thanks!!!!