Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Re: PowerQuery -Date.AddMonths((Date.EndOfMonth(DateTime.Date(DateTime.LocalNow()))), -1)),

I notice when I updated my data for August 2018 PowerQuery calculated the EOMonth for August as August 20, 2018, which is incorrect. The correct date is August 31st. I believe PowerQuery returned the 30th because September ends on the 30th rather than the 31st. So, PowerQuery is taking the end of the current month and assuming the previous month ended on the 30th like the current month. Since some days have 31 vs 30 days, it creates a disconnect.. Could you look into correcting this? Thank you.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base