Tag Archives: DAY

Basic Date Calculations – Power Query vs Excel Formula

Posted on November 19, 2022 by MF

It is quite common to perform date-related calculations when we work with Excel. Before Power Query, we must do it with built-in functions. However, we may not get the results we need with a single function most of the time. … Continue reading →

Rate this:

Posted in Formula, Power Query | Tagged , , , , , , , , , , , | Leave a comment

Determine leap year with #Excel

Posted on February 29, 2020 by MF

Today is a special day.  Today is February 29th, which happens only once every four years.  And today is Saturday, when I usually post a new blog.  So let’s talk about how to determine if a year is leap year using … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , , | 2 Comments

Date Formats – A trick to format date with “st”, “nd”, “rd”, “th”

Posted on November 8, 2014 by MF

Well, there is no such custom format for date in Excel… However it can be achieved indirectly, with helper cell 🙂

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 17 Comments