Year-To-Date Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/year-to-date/ Bestselling Excel and Power BI Courses Thu, 02 Mar 2023 16:41:12 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Year-To-Date Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/year-to-date/ 32 32 How to Use SCAN Function in Microsoft Excel https://www.xelplus.com/scan-function-in-excel/ Fri, 05 Nov 2021 14:44:00 +0000 https://www.xelplus.com/?p=9746 Learn how to use the new Excel SCAN function! This function is a Lambda helper function. You can use it to "scan" a range and apply a calculation to each cell. In this example you'll learn how to use SCAN to get to-date values and how you can tweak it to return YTD values.

The post How to Use SCAN Function in Microsoft Excel appeared first on Xelplus - Leila Gharani.

]]>
Excel SUMPRODUCT – Calculate Year To Date https://www.xelplus.com/sumproduct-year-to-date/ Wed, 30 Nov 2016 10:27:00 +0000 https://www.xelplus.com/?p=13085 Learn how to write dynamic YTD formulas in Excel using SUMPRODUCT, OFFSET & SUM functions, even when your data set goes over a few years, with each month occurring more than once.

The post Excel SUMPRODUCT – Calculate Year To Date appeared first on Xelplus - Leila Gharani.

]]>