I am trying to auto populate rows with the number of days based on a specific date. I enter a date and can get the total number of days in that month but then trying to populate rows with the number of days in that month. The sequence function would work perfectly but I am using excel 2019 which it is not available in. Any help is appreciated
Delete all data from B6 down then try this formula in B6
Formula:
Please Login or Register to view this content.
Audere est facere
Try:Formula:Please Login or Register to view this content.
That works as is in 365. You might need to array enter it 2019.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks, but this just returned a value of 1 into B6 only and trying to populate down to the number of days. this example would be down to 29
Populate days 1-28 then use formulas in the next 3 rows to fill as needed.
Did you enter it as an array formula? After typing in the formula, do not hit ENTER--hit CTRL+SHIFT+ENTER. You have done it correctly if the formula in the formula box has {braces} around it. You cannot type in the braces; they are just an indicator that it is an array formula.Originally Posted by markharris2004
I tried something like that but I have found it problematic to test things that like in 365 and make sure they work in older versions.
Are you using Excel 2019 as per your question or Excel 2010 as per your profile?
Please update your member profile to show what version of Excel you are actually using. Thanks.
Select cells B6:B36. With all the cells selected, paste this formula into cell B6 and commit with Ctrl-Shift-Enter (rather than just Enter)
Formula:Please Login or Register to view this content.
You must first select cells B6:B37, then paste any (they all work) of the above formulas into the formula box. Array commit via CSE.
Non-array formula in B6 and dragged down to B37:
Please Login or Register to view this content.
Ben Van Johnson
If I remember correctly in 2010 forward you can just enter this in B6 and commit with enter. It will spill down the correct number of rows. Please let me know if this worked or not.Formula:Please Login or Register to view this content.
Edit: BTW this is a "trick" I learned from XOR LX a few years back.
Last edited by FlameRetired; 07-04-2025 at 05:51 PM.
Dave
Your forum profile says 2010 - if you are now using 2019, please update it. Thank you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks