How to use the current date in a formula

ferank

New Member
Joined
Apr 18, 2002
Messages
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 :)
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

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?
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,268
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top