DATE function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/date-function/ 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 DATE function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/date-function/ 32 32 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 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.

]]>