•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
WORKDAY Formula showing weekends
Our take
Creating a dynamic calendar in Excel can be a rewarding project, especially when learning to use formulas. If you're encountering issues with weekends appearing in some months while using the WORKDAY formula, it may stem from how the formula calculates working days. The formula you provided, =WORKDAY(WORKDAY(EOMONTH(A3,-1),1),SEQUENCE(,NETWORKDAYS(A3,EOMONTH(A3,0)),0)), is designed to exclude weekends, but variations in month lengths can lead to unexpected results. Let's explore tips to refine your approach and ensure your calendar accurately reflects
Hi! I am VERY new to excel, and learning formulas. I am creating a dynamic calendar (attendance purposes). I was following a video explaining how to create a dynamic calendar with a formula that should be excluding weekends.
However, when I enter the formula, some months (first image) ARE showing weekends, other months aren't (second image). Does anyone have any tips on what to do differently or what I am doing wrong?
This is the formula I am working with:
=WORKDAY(WORKDAY(EOMONTH(A3,-1),1),SEQUENCE(,NETWORKDAYS(A3,EOMONTH(A3,0)),0))
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Wanting to build a check total sheet that references a dynamic calendarI am going to try and Make this as clear as possible but it might be a bit confusing. I am creating a Dynamic Calendar (which it is created and works it seems) to track my work schedule. I work a two week on two week off schedule and I change out on Thursdays. I got it formatted to shade my schedule where I’m at work(not important) and shaded to add extra weeks. I want to create a second sheet that tracks the weeks of work (actually pay periods but both.) Listed as Back, Full and Front Back- is the first week I’m at work Full- well that’s a full week Front- last week or the front half I want column A to be the work week but started on a Monday and the pay period would be the following Friday in column B. Column C would list the type of week and D would be the amount associated with the type of week. My calendar is a grid 3x4 months. from empty first Jan square is B5 and all the way to X37 there is columns and rows spacing each month out In AA4 is the year AA5 is rotation start date AA6&AA7 is days on and off. I have tried using AI I have tried getting it to reference and when I get close the column for Week type does not fill correctly or won’t add an extra week when adding to that boxes or it adds every week possible in the year. I hope that was clear I been messing with it like a day before asking AI. And nothing I do gets it. Either it fills all weeks at full or no full weeks. submitted by /u/Cronenberg_Jerry [link] [comments]
- I am having a issue with a previously working formulaHi, I use Excel primarily on SharePoint to track inspections on a production floor. I have used the same formula for over a year: =IFS(D38=FALSE,"",E38="",NOW(),TRUE,E38). Essentially, when the field is checked off, it autostamps it with the time and date. (See Picture). Since Friday, however, the time and date defaults to what is shown in the picture. Troubleshooting I have tried is confirming that all devices using this sheet are time-synced, up to date, and restarted. I have confirmed that the calculation options are set to automatic and that the formatting is correct for both time and date. I have re-typed the formula as well. I am at a loss, as it was a perfectly functional formula up until Friday. Correct time stamp Error time stamp submitted by /u/Shadynasty8091 [link] [comments]
- Formula for calculating regular and overtime hours based on a full week with an 8 hour day.My excel sheet has multiple employees, dates and the total number of hours worked for that day per employee. I currently have a formula that calculates 40 for the week as regular time then the remainder is overtime but that's not how our overtime works. I need to create a formula(s) to calculate hours per day up to 8 as regular time then the remainder is overtime including all day Saturday and Sunday I know this should not be as difficult as my mind has made it but for the life of me, I can not figure it out, plus I'm old so using AI is out of my scope. For example, Christian only had 26 hours for the week so my current formula does not figure any overtime when he should actually have 16 regular hours and 10 overtime hours. Also for example, Adan should have 24 regular hours and 39 overtime hours. https://preview.redd.it/i0ahs8oaf6yg1.png?width=429&format=png&auto=webp&s=e0e29134a1630561de2bc997571fab197ceabf43 Please help. Thank you! submitted by /u/Ok-Fail-4340 [link] [comments]
Tagged with
#AI formula generation techniques#formula generator#Excel compatibility#Excel alternatives for data analysis#financial modeling with spreadsheets#Excel alternatives#rows.com#machine learning in spreadsheet applications#WORKDAY#formula#weekends#Excel#dynamic calendar#attendance#EOMONTH#SEQUENCE#NETWORKDAYS#tips#dynamic calendar formula#Excel formulas