2021 Archives by date, by thread · List index

# Re: [libreoffice-users] Start Date

```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 <wadesmart@gmail.com> 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 <siefke_listen@web.de> 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: users+unsubscribe@global.libreoffice.org
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/

```
```
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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/