KentKHI
Active Member
- Joined
- Oct 1, 2004
- Messages
- 492
I am currently using a timecard that I built that is not working quite right at the change of the month. We calculate overtime on a weekly basis so if a month ends in the middle of the week, the time needs to be calculated towards the next week for overtime sake.
What I am looking for:
I have two seperate ranges with dates in them. I need a formula to return a true value if there are any dates in either range that are within the same week of the dates in the other range.
Does this make any sense?
What I am looking for:
I have two seperate ranges with dates in them. I need a formula to return a true value if there are any dates in either range that are within the same week of the dates in the other range.
Does this make any sense?