Hello. I am attempting to check to see if the current week is the end of a period or not. If it is, I need to display some text, and if it is not, I need to display nothing.
Since I am Computer Science major, the best way I can describe this is through and if structure from a low-level programming lanuage (like C++ or Java):
Basically, the period and week numbers are already given on the worksheet in C1 and E1 respectively.
If the period number (C1) is 3, 6, 9, or 12 AND the week number (E1) is 5, then I need to display the text. However, if the period number (C1) is 1, 2, 4, 5, 7, 8, 10, 11 AND the week number is 4, then I need to display the text. If the above statements are not true, then no text should be displayed.
I have messed around with the IF function using AND and OR functions, however, I can just not get this to work.
If I was more comfortable implementing VB into worksheets I'd probably take this route, however, I am kind of unfamiliar with VB.
I hope my explanation of my problem was sufficient for someone to understand and any help is greatly appreciated!
Dan
Bookmarks