• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Please help converting a 'Today()' formula to account for weekends

M

Mike Wyller

New Member
Hi Friends,

I have some formulas that are used as CF rules, but need to change them to account for weekends. (Count Workdays only). Can someone help me?

Existing formulas;
=AND(TODAY()-$O2>=0, TODAY()-$O2<=2)
=AND(TODAY()-$O2>=3, TODAY()-$O2<=5)
=TODAY()-$O2>5
 
Maybe,

=AND(TODAY()-$O2>=0,TODAY()-$O2<=2,MOD($O2,7)>1,MOD(TODAY(),7)>1)
=AND(TODAY()-$O2>=3,TODAY()-$O2<=5,MOD($O2,7)>1,MOD(TODAY(),7)>1)
=AND(TODAY()-$O2>5,MOD($O2,7)>1,MOD(TODAY(),7)>1)

Regards
Bosco
 
Last edited:
Thanks Bosco!
Doesn't MOD() just do division of values?
I thought I would need some combination of Networkdays.Intl() and the existing formulas I have now.
I will test what you've provided and see..
Thanks again!
 
MOD actually returns remainder of division, not just do division of values.

Ex: MOD(4, 3) = 1
MOD(4, 4) = 0
 
You must log in or register to reply here.
Back
Top