Forum Discussion
Help Needed: Excel 2019 Formula to count date ranges
I am trying to chart quantities of "eligible upgrade dates" based on a column of dates, some of which are in the past, in groups of: "Eligible now" (Today or any date BEFORE today), Within the next ...
I don't see an attachment.
If you don't see an area with "Drag and drop here or browse files to attach" below the area where you compose a post, you can make a sample workbook available through OneDrive, Google Drive, Dropbox or similar, and post a link to the uploaded and shared workbook.
- https://1drv.ms/x/s!ArW-WPwPu2B3ga5NoTcRrVygS0_KTQ?e=mhamEx
Thanks. The formulas are OK.
The values from A4 down look like dates, but they are text values. Could they have been copied from another source?
To remedy this, select all 'dates' from A4 down.
On the Data tab of the ribbon, click Text to Columns.
Click 'Next > ' twice.
Select Date, and select MDY from the drop down next to it.
Click Finish.
You should now have 'real' dates, and the formulas should work.
- WOW Hans, THANK YOU so very much! I had selected all the cells in the column and did a "format cells" to a date, but I guess the export of the data is a bit more finnicky. Thanks again for the 2nd set of eyes on this.
