Calculations of weeks not showing in whole figures

Susanna Ferry

I am trying to calculate the dwell time for each project, by using the start date & a formula to change the date daily to todays date, however the final figure is coming up with additional decimal places, is there any way to round this figure down / up

This is the formula I am using

JamesB

@Susanna Ferry

There are ROUND, ROUNDUP and ROUNDOWN formulas in SS. For all of these the arguments are the same, ROUND will automatically round up or down based on which whole number is closest, ROUNDUP will round to the next whole number, and ROUNDDOWN to the lower whole number.

i.e =ROUND(([Progress As Of Today]@row - [Start Date of Project]@row) / 7,0)

Susanna Ferry

Thank you so much for your help, I will give this a go