Excel Forum

Calculate production flow dates

Dan Taba

New Member

Members

Forum Posts: 1

Member Since:
April 13, 2020

Offline

April 13, 2020 - 3:06 am

Hello,

I am trying to define a way to automatically calculate the start date (tab Timeline) of a production operation (WK09) knowing that the task length is 18 hours; however the number of available time to work on the operation varies according to the day of the week (see tab Work Center).

Please note I am not using Excel 365

Thank you so much

DanT

Catalin Bombea

Iasi, Romania

Member

Dashboards

Power Query

Power Pivot

Xtreme Pivot Tables

Excel for Decision Making

Excel for Finance

Excel Analysis Toolpak

Power BI

Excel

Word

Outlook

Excel Expert

Excel Customer Service

PowerPoint

Forum Posts: 1939

Member Since:
November 8, 2013

Offline

April 16, 2020 - 4:52 pm

Hi Dan,

There are still some things not very clear:

WK09 is a week number? If so, why you have the Start Date in week 9, when the end date 27/05/2020 is in week 22 ?

I assume you would manually input the end date and you want the start date to be determined?

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Velouria, Riny van Eekelen

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Catalin Bombea: 1939

SunnyKow: 1432

Anders Sehlstedt: 925

Purfleet: 415

Frans Visser: 349

Hans Hallebeek: 343

David_Ng: 312

lea cohen: 248

Jessica Stewart: 219

A.Maurizio: 216

Newest Members:

Hiroyuki Murai

Mark Allen

Yves Gagnon

PATRICK WALTER

Carley Brice

Ash Rahman

Christelle Lamprecht

Wei Kwok Tey

Partha Pratim Nandy

Inge Rousseau

Forum Stats:

Groups: 3

Forums: 25

Topics: 7087

Posts: 31062

Member Stats:

Guest Posters: 49

Members: 34503

Moderators: 2

Admins: 3

Administrators: Mynda Treacy, Philip Treacy, Jessica

Moderators: Velouria, Riny van Eekelen

Calculate production flow dates|General Excel Questions & Answers|Excel Forum|My Online Training Hub