Hello,
I am trying to test out an application where the assignment of period and quarter is done automatically. Please see the attached.
code is:
In the above code, what I'm trying to do is......if it is community, then first check and see if both the date of clinic and date of referral fall under the same period. If so, assign period and quarter based on the date of clinic.Please Login or Register to view this content.
What I'm trying to add is.......if it is a community patient, and if the date of referral is BEFORE the date of clinic, I want Excel to assign the period based on the date of clinic. For example, if date of referral is in period 4 but the date of clinic is in period 5, then I want this patient to be in period 5, but not 4.
How should the syntax go in the code above?
Could anybody help?
Thank you
Bookmarks