Hey, Tony--
What am I doing wrong? I'm not getting a value of 1, 2, 3, 4, or 5 in C2. See attached.
John
Now everyone in Youngstown goes to Pittsburgh to party!![]()
Hey, Tony--
What am I doing wrong? I'm not getting a value of 1, 2, 3, 4, or 5 in C2. See attached.
John
Now everyone in Youngstown goes to Pittsburgh to party!![]()
I downloaded the file and it shows the correct result of 3.
B2-A2 = 21
21 falls into category 3:
If date in B2 - date in A2 is 1 or less days, put a 1 in cell C2.
If date in B2 - date in A2 is 2-7 days, put a 2 in cell C2.
If date in B2 - date in A2 is 8-30 days, put a 3 in cell C2.
If date in B2 - date in A2 is 31-90 days, put a 4 in cell C2.
If date in B2 - date in A2 is 91 days or more, put a 5 in cell C2
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks