Months Between

Question

How can I find the months between the Calendar Day and today.&nbsp;&nbsp;This should be for each&nbsp;Material.Material level&nbsp; 01 key.&nbsp;&nbsp;

freemanz · Answer

hi amandabus21&nbsp;try to add a calculated&nbsp;column like:Months =DATEDIFF([Calendar Day], TODAY(), MONTH)

amandabus21 · Answer

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

freemanz · Answer

hi amandabus21&nbsp;do you mean a column like:DAY([Calendar Day])

amandabus21 · Answer

No for example it would be 1 month if it was exactly the day&nbsp;So 3/21/2023 would be 1 month (from today 4/21/23)&nbsp;But 3/30/23 shouldnt be 1 month because today is (4/21/23) and technically a full month hasnt passed.&nbsp;I used the first formula you provided and named Age Buckets.&nbsp;&nbsp;

amandabus21 · Answer

FreemanZ&nbsp;any update on this?

Forum Discussion

Months Between

5 Replies

Related content

Month to Month Flow Calculation

Month over Month with multiple text values

Current Month , Previous Month and Before Previous Month

Counting Active employees per month

Total per month / average per month