# Help with Formula in Excel

#### ashleykate7

##### New Member
I am trying to create a formula to add days from a certain date. If I want to use May 1st, 2008 as my starting date, I want to calculate the number of days from that date to "today's" date. I am trying to figure the amount of Late Fees that are due (each day the spreadsheet is viewed) and I want the excel spreadsheet to manually calculate what is due and add additional dates. Below is an example:

May 1st 2008 Rent- 304 days late *\$25 a day = \$7,600
June 1st 2008 Rent- 273 days late *\$25 a day = \$6,825
July 1st 2008 Rent- 243 days late *\$25 a day = \$6,075

So when I open the spreadsheet tomorrow, I want that May column days late to show 305, June column days late to show 274, and July column days late to show 244. Any advice or assistance would be greatly appreciated. Thank you, Ashley

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
I'm coming up with a difference of 2 days from your results.

Put =TODAY() in a cell and then subtract the starting date from it. Put your late rate in another cell and multiply these results by it.

Excel Workbook
ABCDEFGHI
15/1/20083067650Today:3/3/2009
26/1/20082756875Late Rate:25
37/1/20082456125
Sheet1

Assuming the dates of 1 May 2008 is in a row say B1, and so on

=TODAY()-B\$1

That is 306 though not 304.

I was using March 1st instead of todays date, so this will work out great. Thank you for your help. Ashley

Replies
8
Views
383
Replies
2
Views
162
Replies
14
Views
883
Replies
2
Views
403
Replies
1
Views
243

1,203,356
Messages
6,054,938
Members
444,759
Latest member
TeckTeck

### 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.

### Which adblocker are you using?

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

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