Forum Discussion

ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
5 years ago

Counting Months based on two date field with rounding

Hi,  Need some help with a formula to count the number of months by referencing start and end date fields. I need this to round to the nearest whole number. The formula I'm currently using is below...
Formulas and functions
LisaSell1's avatar
LisaSell1
Qrew Trainee
5 years ago
I tried this:
var date SD=[Actual Start];
var date ED=[Actual End];
var number NumMonths =
Floor(ToWeeks([Actual End]-[Actual Start]) /4.345);

$NumMonths


I made a formula on the report & specified 2 decimal places - you may have to adjust the rounding