FeignedInterest
New Member
- Joined
- Feb 11, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi All,
I've looked through Google and this forum but can't find an answer to this specific issue. Apologies if it was out there and I missed it. I'm not an expert by any means, my formulas may look convoluted.
I have columns like these where they highlight to different colors based on dates in other columns. I was successful using DATEDIF but then realized I need this to ignore the weekends.
I have tried the following formula and although Excel accepts it, it isn't ignoring the weekends. Also, I tried WORKDAY instead of WEEKDAY but it wasn't successful.
I greatly appreciate any help you can provide. Thank you.
I've looked through Google and this forum but can't find an answer to this specific issue. Apologies if it was out there and I missed it. I'm not an expert by any means, my formulas may look convoluted.
I have columns like these where they highlight to different colors based on dates in other columns. I was successful using DATEDIF but then realized I need this to ignore the weekends.
I have tried the following formula and although Excel accepts it, it isn't ignoring the weekends. Also, I tried WORKDAY instead of WEEKDAY but it wasn't successful.
I greatly appreciate any help you can provide. Thank you.