Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
Thanks for the challenge. I've definitely learn something new using the datetimeparse functions. But the question should've been a little specifics and it should've specify "calculate the average hotel stay and count the number of reservation....... in each month"
Admittedly, this was my first experience with the DateTimeParse() formula. Very handy! Much better than creating a lookup table to convert month names to numbers.
Also excluded "No-show" reservations just to be sure.