Conditional Date Calculation after conditions have been checked

[msgman]

I'm trying to write a formula to calculate how many days an employee worked here and if they started training. Below the requirements:

1. Our work week is Monday - Saturday
2. No shows have the same start and end date
3. There is a toggle field with Y or N if they started training or not.
4. If they did not start training, the start and end date of employment are the same and should return "0"
5. If they did start training and the start date is >= the end date, it should return the number of days worked, however, IF the start and end date are the same and they started training, the result would be 1

Currently, if I use this formula it will only count the days between the start and end date and if the start and end date are the same, it will return 1, but doesn't check if training was started or not. If training was not started, and the two dates are the same it should return 0.

Here is what I have, but it's not working...

Column I = Start Date
Column M = Term Date
Column H = Training Started "Y" or "N"

=IF(OR(I328<=M328,I328>M328),”0”, IF(H328="Y",=SUM(INT((WEEKDAY(I328-{2,3,4,5,6,7})+M328-I328)/7))))

[ChemistB]

You don't mention some possible combinations but I will assume that is because they never happen.
=IF(H328="N", 0, IF(H328 = "Y",NETWORKDAYS(I328, M328),""))
This will give a 1 if start and term are the same (and training = Yes). It counts the first day as 1 so if there is a difference of 1, then the employee has worked 2 days. Does this work for you?

[msgman]

Thank you for your response. I think I have solved my problem with the formula below. The problem with the NETWORKDAYS is it excludes Saturday and Sunday, so I used the WEEKDAY function to select which days of the week to calculate, we work Monday-Saturday. I added the ISBLANK to check if either the start or term date are blank it will leave the Days Worked Cell blank vs an invalid number. I'm going to do some error checking now, but so far this seems to have worked.

=IF(H328="N","0", IF(OR(ISBLANK(I328),ISBLANK(M328)),"",IF(H328="Y", SUM(INT((WEEKDAY(I328-{2,3,4,5,6,7})+M328-I328)/7)))))