Date Synch

%3CLINGO-SUB%20id%3D%22lingo-sub-1204075%22%20slang%3D%22en-US%22%3EDate%20Synch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204075%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20would%20like%20to%20know%20if%20it%20is%20possible%20to%20connect%202%20Dates%20that%20they%20will%20continue%20automatically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%20Max%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1204075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1204176%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Synch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572128%22%20target%3D%22_blank%22%3E%40MaxLnr%3C%2FA%3E%26nbsp%3BThe%20WORKDAY%20function%20should%20get%20you%20very%20close.%20You%20haven't%20described%20your%20rules%20for%20determining%20the%20second%20date%20from%20the%20first%20date%20and%20the%20supplied%20number%20(as%20I%20am%20guessing%20is%20your%20actual%20question).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

 

i would like to know if it is possible to connect 2 Dates that they will continue automatically.

 

Kind regards Max 

1 Reply
Highlighted

@MaxLnr The WORKDAY function should get you very close. You haven't described your rules for determining the second date from the first date and the supplied number (as I am guessing is your actual question).