Date Formula Assistance

CJ Dijkstra

Good day,

I need assistance in setting up a formula for tracking next service dates on equipment. I have two sheets - Sheet 1 is a schedule of Workdays and Sheet 2 is where the various equipment are listed with previous service dates etc.

Sheet 1:

Sheet 2:

C3: Workdays: C1/C2

Question 1 C4: C3 + C7 (this must be based on Workdays from Sheet 1)

Question 2 C9: (C8 - C5) / C2 + C7 (this must be based on Workdays from Sheet 1)

Thanks

CJ

Bassam Khalil

Hi @CJ Dijkstra

Hope you are fine, if you mean that if the result of the formula produce a date that is coming in non-workday then you want it to be shifted to the next working day then you can do that by using if statement using the function WEEKDAY then if the result was 1 which mean Sunday you add 1 day to the date and if it's 7 which mean it's Saturday you add 2 day.

Check my post How to combine an IF statement with Workday and MAX functions you will find the same case that i create the formula to solve it.