Middle day of 2 dates

[ankitsingh2063]

Hello,

I have 2 columns with dates (Previous Date and Next Date). There is always a gap of 14 to 15 days between these 2 dates

I need to find the middle date between these 2 dates - ensuring that month change between these 2 dates does not skew my output

[kcgreen]

If your dates are in a Date format already, you can get the difference between the two dates, divide that by two, then add that to your earliest date.

DateTimeAdd([Previous Date],(DateTimeDiff([Next Date],[Previous Date],"days"))/2,"days")

[DataMeister]

Thanks to KCGreen for solving the same problem for me! Now it's time for Alteryx developers to make this as easy as Excel does it: MEDIAN(Date 1, Date 2) and that's all.