March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Dear, how are you?
I am a bit new to this topic and I am trying to make a calculation that I could not ....... I have a table that has a date which is generated when entering a request in my system, also with a series of additional data, within which I have an ID that identifies a supplier, which has x days defined to comply, but those days should only be considered the working days.
Result = OC Date + Comp Days (only counting working days)
Someone can help me find how to solve this...... would appreciate it very much
Thank you very much for the answer, but what I need is.
I have a departure date and I have other data which indicates the number of (business) days that I have to add to that departure date.
I have only managed to add the days to my departure date, but these are added to me continuously
Struggling to undestand the question (although your English is better than my Spanish), but have you looked into "NETWORKDAYS" to get just the Business/Week/Working days.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
86 | |
84 | |
76 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |