Split date ranges from cells with #Excel #PowerQuery


Take a look at the challenge presented above.Β  Is it possible to do it in Excel?

Be honest, without Power Query, I have no idea how to do it but manual work. πŸ˜πŸ€¦β€β™‚οΈ

Believe it or not, with Power Query, this challenge can be solved in just a few minutes.

Power Query skills involved:

  • Split column by delimited into rows and columns
  • Convert date into number
  • Add conditional/custom column
  • Create a list of number based on two numbers
  • Expand list into new rows


Let’s watch it in action in my YouTube Channel:

You may download a Sample FileΒ to follow along.

English VO


Cantonese VO


I hope you like this video. If you do, please give a thumb up, share and subscribe. πŸ˜‰




About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Power Query and tagged , , , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.