Months Between

[amandabus21]

How can I find the months between the Calendar Day and today. 

This should be for each Material.Material level  01 key.

[amandabus21]

@FreemanZ any update on this?

[FreemanZ]

hi @amandabus21 

try to add a calculated column like:

Months =

DATEDIFF([Calendar Day], TODAY(), MONTH)

[amandabus21]

Thank you, is there a way I could get it down to the DayNumberOfMonth of the Current Date?

[FreemanZ]

hi @amandabus21 

do you mean a column like:

DAY([Calendar Day])

[amandabus21]

No for example it would be 1 month if it was exactly the day

So 3/21/2023 would be 1 month (from today 4/21/23)

But 3/30/23 shouldnt be 1 month because today is (4/21/23) and technically a full month hasnt passed.

I used the first formula you provided and named Age Buckets.