Help Needed with Date Calc

[DrWill]

Hi All,

Completely lost on this one.

I am trying to set up a calc for interest charges for the remainder of a current month.

The data that is available is the "start date" and the "Interest Per Day Charge". Need the formula to count the remaining days for the given month, then multiply by the per day cost to return a value of interest due.

Example:

Start Date - 11/22/2011

Per Day Charge - 25.00

Number of days - (the result would be the number of days remaining in the calendar month, including the start date) so in this example the result would be 9 based on 30 days in Nov) Obviously the calc would need to adjust automatically based on the number of days in a given month.

Any help would be greatly appreciated.

Dave

[comment]

Try =

Per Day Charge *  ( Date ( Month ( Start Date ) + 1 ; 1 ; Year ( Start Date ) ) - Start Date )

[DrWill]

Perfect, thank you