How to list down missed date from date field, excluding weekend (Saturday, Sunday).

[Shibasisnamdev]

How to list the missing date?
Please help.

[Luke_C]

Hi @Shibasisnamdev 

Can you share the data instead of a screenshot? Can you also explain the logic? For ID 1, why are July 9th and 10th not listed? Maybe because it's a weekend?

[Shibasisnamdev]

Hi Luke
Thank you for your reply.

Yes, it's excluding weekends all the missing dates should list down.

Thank you

[DataNath · Accepted solution]

How's this @Shibasisnamdev? It takes the Min/Max date for each ID, generates all days between those, excludes weekends, puts the dates into a format which match your original and then conducts a join based on that. Those that don't find a join from the right data source are the missing dates and so we just assign them an [Hours] amount of 8 and use a Select to format as desired:

[Luke_C · Accepted solution]

Hi @Shibasisnamdev 

Here's one way, generating a row for each date between the min and max for each ID, then filtering out weekends:

[Shibasisnamdev]

Awesome...

Thank you so much @DataNath

[Shibasisnamdev]

Thank you so much Luke.
This community is really alike heaven of solutions for a new developer.