WEEKDAY Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/weekday/ Bestselling Excel and Power BI Courses Mon, 24 Apr 2023 16:11:14 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png WEEKDAY Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/weekday/ 32 32 How to Create a Yearly Calendar with ONE Excel Formula (Use in Google Sheets too) https://www.xelplus.com/calendar-excel-formula/ Thu, 12 Nov 2020 10:00:00 +0000 https://www.xelplus.com/?p=10532 Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.

The post How to Create a Yearly Calendar with ONE Excel Formula (Use in Google Sheets too) appeared first on Xelplus - Leila Gharani.

]]> How to Work with Time in Excel Power Query https://www.xelplus.com/power-query-time-calculations/ Thu, 20 Aug 2020 09:00:00 +0000 https://www.xelplus.com/?p=10801 Working with time in Excel - for example calculating hours worked or summing or subtracting time can get tricky with Excel formulas. Let me show you how Power Query can easily do these for you.

The post How to Work with Time in Excel Power Query appeared first on Xelplus - Leila Gharani.

]]> Create an Excel Calendar with Holidays and Appointments https://www.xelplus.com/excel-calendar-with-holidays-and-appointments/ Mon, 30 Dec 2019 14:10:00 +0000 https://www.xelplus.com/?p=9328 Download this free Monthly Excel Calendar with holidays and appointments. It automatically adds standard holidays like Easter and New Year's - you can also use it to keep track of your appointments.

The post Create an Excel Calendar with Holidays and Appointments 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.

]]> Excel Pivot Chart with Slicers https://www.xelplus.com/pivot-slicer-excel/ Thu, 13 Jul 2017 18:03:00 +0000 https://www.xelplus.com/?p=12179 In this tutorial you'll find out to how to use Pivot Slicers in Excel and create Slicers for months based on dates. You'll also learn how to create a dynamic Pivot Chart controlled by the slicer.

The post Excel Pivot Chart with Slicers appeared first on Xelplus - Leila Gharani.

]]>