3 Replies Latest reply on Jan 3, 2011 11:51 AM by philmodjunk

    Calculate #of days B/W two Dates



      Calculate #of days B/W two Dates


      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.