Forum Discussion
Solved
How do I divide by just the whole number and not the formula?
I am trying to divide 2 cells. One cell is a number I put in and the other is calculating how many biweeks there are in between (=DATEDIF(A2,B2,"d")/14) so when I divide the number I wrote in by the...
You may wrap it by ROUND() to round, or use INT() to cut decimals or similar functions - depends on how you'd like to calculate. As example
=ROUND(DATEDIF(A2,B2,"d")/14,0)or more simple variant
=ROUND( (B2-A2)/14,0)
Since actually number of weeks returned is 18.07143
SergeiBaklan is there a way to just have it dive by the integer and not the number with decimals?
You may wrap it by ROUND() to round, or use INT() to cut decimals or similar functions - depends on how you'd like to calculate. As example
=ROUND(DATEDIF(A2,B2,"d")/14,0)or more simple variant
=ROUND( (B2-A2)/14,0)SergeiBaklan yes!!! You are correct, thank you so much!
