•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What formula to use to count days after a date in a table?
Our take
Are you struggling to calculate the number of days since your clients' last visit using your spreadsheet? You’re not alone—many find traditional formulas confusing, especially when working with multiple date columns. The good news is that with a simple formula, you can easily track this vital information. By leveraging Excel’s built-in functions, you’ll learn how to create a new column that dynamically counts the days since the most recent date entered.
I have a spreadsheet that contains a table. In this table there are many columns, but there are 9 that I am referencing for this. They all contain either dates or are blank, and from left to right in the row it is ALWAYS in chronological order. Think of them as dates a client comes in. Example may be column 1 has 2/4/2023, column 2 has 3/5/2024, column 3 has 5/25/2025, and columns 4 through 9 are blank (but won't be forever). I want to add another column that shows the amount of days since the most recent date they came in.
I tried Google and ChatGPT and nothing worked. It kept spitting out weird dates and when I converted it to numbers it was all wonky.
FYI - for the designation for the formula I tried both the column names and the cell numbers ranges - neither worked.
BONUS QUESTION - For clients names in each row that have a year or more on this counter, how would I create a list of these people? I am a Padawan of Excel 😂
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to automatically assign a number determined by the rank in a series of dates ?I'm sure it's trivial for you excel wizards but I haven't found a way to do this yet : I need to generate a number in column A that's a function of the chronological order of the corresponding date in column D, ie the earliest date gets "1" and so on (this spreadsheet is completed on the fly so the column D is manually updated with the date when the customer sends me what I need, so the column A stays blank when there's no matching date, for which I'll just use a IF() function), see pic : https://tmpfiles.org/25810180/screenshhh.png I googled quite a bit and still haven't found a function that does this. I use office 360 though not the latest version. Sorry for the broken English ! submitted by /u/aktor55 [link] [comments]
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
- Counting date entries in csv spreadsheetI have entries similar to the ones below. I have 1500 rows of data. Out of this, all I care about is how many entries I got each day. So for 8/19/2025 id like it to return 2, 8/20/2025 it returns 4 and so on. I was going to do a countif command using =COUNTIF(B2:1479, 8/19/2025) then =COUNTIF(B2:1479, 8/20/2025) but it returns 0 for both. I assume its looking at the time in the value so it does not meet the criteria. 8/19/2025 13:51:20 PM 8/19/2025 18:52:01 PM 8/20/2025 10:42:01 AM 8/20/2025 10:43:01 AM 8/20/2025 10:43:01 AM 8/20/2025 15:06:01 PM 1/20/2026 3:07:01 AM submitted by /u/shadow8164 [link] [comments]
- Counting longest spurt of consecutive cells with valueHey y’all! In my data I have a row for every 6 hours for 12 months and a column with varying values for each row. Like, A B 1/1/2026 0:00 -9.76 1/1/2026 6:00 -12.54 etc. I need to count what was the longest length of time the values were above -12 for the entire year. Any ideas on how to do this? I’m open to any solutions be it formulas, power query, or macros/VBA. I’m on 365 on a desktop. I’m currently cleaning up a bunch of data sheets other people made and this is a task we have to do frequently. In this workbook I’ll have to do it on 20+ columns and then do it again on each column for subsets of the time we have data for. Their current solution is a C column with =IF(B2>=-12,C2+.25,0) to count the days >-12 in a row in 6 hour increments. Then in column D they have =IF(C3>C2+C4,C3,0) to have a column with just the max value of each consecutive spurt of time. At the end they run =MAX(D2:D1459) to get the longest spurt. Then they add 2 more columns for each subset of time they want to look at. It takes up half the workbook. submitted by /u/CompetitiveDuck495 [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#row zero#AI formula generation techniques#rows.com#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#google sheets#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#days since#Excel#spreadsheet