Finding max date in a week

Question

I was trying to find the difference of date in a series of date range and sum of the dates in days in a week if any day is missing.

I think it a bit confusion 😕. I had attached the excel file where you can get a good examples.

Expecting a workflow solution.

Cheers.

test.xlsx

PNC97 · Answer

Let me explain you in this way

I'm working for a week ie. from Aug 1st to 7th with daily 10 hrs of work and in between the Aug 1st to 7th I Didn't worked on Aug 4th now the

* 1st output in new column should be sum of the hours worked in between Aug 1st to 7th by leaving Aug 4th.
* 2nd Output should be the hours between Aug 3rd last out to Aug 5th 1st In.

And here are the new input files.

Book1.xlsx

mbarone · Answer

Still can't tell what you're looking for from your spreadsheet.  What are the incoming fields and values, and what do you want for new columns and values?

PNC97 · Answer

Yes Tried but didn't worked with the Date function and multi row formula

IF (DateTimeDiff([Date 1],[Row-1:Date 1],"days") != 1) and (DateTimeDiff([Date 2],[Row-1:Date 2],"days") != 1) THEN [Date 1] ELSE Null() ENDIF