To get the number of work days: =workday(end date; -25) https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_WORKDAY_function
And assuming each service gets a different date: =workday(end date; -service B) You can do a lookup table for each service. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Mon, Jun 14, 2021 at 5:58 AM Wade Smart <[email protected]> wrote: > > Question: does the meter per day have any relevance to the date? > Is a working day equal to a business day? -> Mon - Fri only? > > > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > On Mon, Jun 14, 2021 at 5:44 AM Silvio Siefke <[email protected]> wrote: > > > > Hello, > > > > I have a table like: > > > > 11.04.2022;service a;250 > > 12.04.2022;service a;250 > > 13.04.2022;service a;250 > > 14.04.2022;service b;250 > > 15.04.2022;service b;250 > > 12.05.2022;service b;250 > > 13.05.2022;service c;250 > > 14.05.2022;service c;250 > > 17.05.2022;service d;250 > > 18.05.2022;service d;250 > > > > Service a need 10 meters par day. > > Service b need 1 meters par day. > > Service c need 3 meters par day. > > Service d need 5 meters par day. > > > > This mean 11.04.2022 - 25 working days = Project Start Day. > > > > The date is enddate, I need the start day based on service values of meters > > and only working days. > > > > Is there a way? > > > > Thank you > > Silvio > > > > -- > > To unsubscribe e-mail to: [email protected] > > Problems? > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > > List archive: https://listarchives.libreoffice.org/global/users/ > > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
