### Title

Calculate #of days B/W two Dates

### Post

I am a FM pro11 om windows platform.

I want to calculate payments based on the PMT function but I want to be able to input the first payment due date instead. Therefore the first payment date may be greater or fewer than the interest start date. So I must be able to calculate the number of days from interest start date & the first payment due date then incoporate that into the PMT function. I also am not sure on that either so all the help you can give would be greatly appreciated.

Thanks.

To compute the number of days between two date fields, just subtract them. This requires that both dates be entered into different fields of type date.

Date2Field - Date1Field

will compute the number of days from Date 1 to Date 2.