Forum Discussion
Excel Date calculation formula
Good Morning, I'm new to this forum. I have an intermediate knowledge of Excel (Mac Office 365) and need help with a date formula. Basically, it goes like this: I have to create a payment schedule. I...
If you want equally spaced payments, then with 7/20/2022 in B3 and 7/20/2024 in B8, enter the following into B4 and copy into B5:B7:
=ROUND($B$3 + ROWS($B$4:B4)*($B$8-$B$3)/5, 0)
Format appropriately. My results:
-----
PS.... You did not ask for help with calculating payment amounts, but now I see that you wrote "remainder?". Try the following.
THIS is awesome, thank you so much for the more than thorough response. First time in this forum, this is great!