Date calculator

Question

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 DateEnd DateWorking Days between Start Date and End date2022-02-02 17:00:002022-09-02 14:31:36?2/14/2022 5:00:00 PM2/14/2022 5:07:16 PM?

Thanks

binu_acs · Answer

@ag72 One way of doing this

Date_140313_01.yxmd

FinnCharlton · Answer

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!

Count Working days.yxmd