Rounding Dates

[kcrabb2]

Hi!

I have a sheet that includes looks like the below table. What I would like to do is take the invoice date, add the terms and come up with a payment date that is rounded to either the 10th or the 25th of the month, since those are the days we do our check runs.

Thanks!

[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]Invoice Date[/TD]
[TD]Terms[/TD]
[TD]Payment Date[/TD]
[/TR]
[TR]
[TD]10/20/2015[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/10/2015[/TD]
[TD]45
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[pgc01]

Hi
Welcome to the board

What kind of rounding? up, down, to the nearest?

 

[kcrabb2]

Round tot he nearest.

 

[ImranMalek]

Hi,
Considering you have Invoice date and Tems in Cell A1 and B1 respectively , try this formula in C1

=IF(25-DAY(A1+B1)>10,10,25)

Stay tuned for a better formula from pgc01