Dates Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dates/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 08:49:18 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Dates Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dates/ 32 32 How to Calculate the Number of Days Between Two Dates in Excel https://www.xelplus.com/calculate-working-days-excel-exclude-some-days/ Thu, 05 Aug 2021 08:00:00 +0000 https://www.xelplus.com/?p=9907 It's easy to calculate the difference between dates in Excel and exclude weekends and holidays. But how can you exclude ANY weekday of your choice? There is an Excel trick you can use.

The post How to Calculate the Number of Days Between Two Dates in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel’s STOCKHISTORY Function https://www.xelplus.com/excel-stockhistory-function/ Thu, 28 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=8967 The StockHistory Function in Excel allows you to easily pull historical stock data in Excel with a single formula. You can get daily, weekly or monthly data. Find out how to use this together with sparklines to visualize the trend of different stocks in one view.

The post How to Use Excel’s STOCKHISTORY Function appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel’s Amazing Flash Fill https://www.xelplus.com/excel-flash-fill/ Thu, 07 Nov 2019 10:00:00 +0000 https://www.xelplus.com/?p=11790 Excel's Flash Fill feature can save you a ton of time! Check out how you can automatically split names, get the initials, email addresses and more with Excel's amazing Flash Fill feature. No more writing complex formulas.

The post How to Use Excel’s Amazing Flash Fill appeared first on Xelplus - Leila Gharani.

]]> Count Day of Week Between Dates in Excel (How many Fridays?) https://www.xelplus.com/count-how-many-fridays/ Thu, 03 Jan 2019 16:24:00 +0000 https://www.xelplus.com/?p=9304 Learn how you can use the NETWORKDAYS function to calculate the number of Fridays (or other days of the week) between two dates.

The post Count Day of Week Between Dates in Excel (How many Fridays?) appeared first on Xelplus - Leila Gharani.

]]> Excel SUM Between Dates https://www.xelplus.com/excel-sum-between-dates/ Fri, 27 Jul 2018 17:45:00 +0000 https://www.xelplus.com/?p=10475 Excel's SUMIFS function makes it super easy to sum values that fall between two dates. You'll also learn how to sum by month and also add in multiple criteria.

The post Excel SUM Between Dates appeared first on Xelplus - Leila Gharani.

]]> Excel Reset Week Number Every Month (start from Week # 1 every new month) https://www.xelplus.com/reset-week-number-every-month-excel/ Fri, 15 Dec 2017 09:07:00 +0000 https://www.xelplus.com/?p=11223 Find out how you can use the WEEKDAY and WEEKNUM functions in Excel to be able to reset the Week Number at the beginning of every month.

The post Excel Reset Week Number Every Month (start from Week # 1 every new month) appeared first on Xelplus - Leila Gharani.

]]> Skip Dates in Excel Charts https://www.xelplus.com/skip-dates-in-excel-charts/ Thu, 07 Sep 2017 10:40:00 +0000 https://www.xelplus.com/?p=11958 Learn a simple method to deal with gaps in your data, specifically missing dates. You don't want to display them in a chart, but Excel treats a date axis as continuous and will try to connect the line.

The post Skip Dates in Excel Charts appeared first on Xelplus - Leila Gharani.

]]>