Date calculator

[ag72]

Hello, 

I need to calculate the working days (by excluding Sat, Sun only no need to take public holidays into consideration) between 2 columns which have the dates available. But my problem is that my data in the dates have mixed format of dates in both the column (as shown below), so what's the efficient way to change and calculate?

Start Date	End Date	Working Days between Start Date and End date
2022-02-02 17:00:00	2022-09-02 14:31:36	?
2/14/2022 5:00:00 PM	2/14/2022 5:07:16 PM	?

Thanks

[FinnCharlton]

Hi @ag72 , I would approach it like this:

The multi-field formula conditionally parses the dates based on their format:

We then generate a row for each day between the two dates, filter out the weekends, and count the days remaining. Hope this helps!

[binuacs]

@ag72 One way of doing this