I'm very new to Alteryx and trying to create a workflow. My data set contains start and end dates for various projects. I need to calculate the number of days and the number of months between the beginning and end dates of each project.
Issue:
I am getting variances between the Excel and Alteryx calculations. While minor, they can add up to a material impact on my calculations. I figured out how to tweak the Alteryx formula for "number of days" to match my Excel output, but I can't figure out how to do the same for number of months.
Questions:
1. Can you please help me figure out how to get my Alteryx calculation to match my Excel calculation/ output?
2. Is the "unedited" Alteryx calculation more accurate than my Excel calculation?
Details:
@Astro55 I calculated the month difference using the formula DATEDIF(date1, date2,'m') in excel I got the same result as Alteryx, seems to be you are adding 1 to the excel formula result and comparing with Alteryx result. Can you check again? The below red color box I added in excel sheet
@Astro55 Is there any reason why you are using FLOOR() function?
@binuacs - firstly, thank you SO much for being so responsive!!!
The floor function was suggested by @BRRLL99 . So I tried that to see if it would get me closer to my required solution.
To answer your question about the +1... the difference is due to how the DATEDIF formula is being used:
I apologize that this is so frustrating and confusing. I'm still super new to Alteryx, and just learning what I can and can't do in Alteryx.