B
BCNU
I have contact birthday information in column K and each member of a family
in different rows (for this family it's rows 13-15) and the anniversary is in
cell L13 in this example. I use the following formula to show me if anyone
has a celebration due during the current month (month(now()) and I get funny
results. When I click on the Fx feature, I get the logical test and the
formula result=volatile. I'm trying to see if any one of the 3 have a
birthday in this month, or if the paretns have an anniversary in this month,
then show the words "this month" in my formula column (column a) but one
formula per family. Can you see what I'm doing wrong?
=IF(OR(MONTH(K13)=MONTH(NOW()),MONTH(L13)=MONTH(NOW()),MONTH(K14)=MONTH(NOW()),MONTH(K15)=MONTH(NOW())),"THIS MONTH","")
I'm using Excel 2003, windows XP if you needed this. It had been working
but going from Dec to Jan seems to have done something.
in different rows (for this family it's rows 13-15) and the anniversary is in
cell L13 in this example. I use the following formula to show me if anyone
has a celebration due during the current month (month(now()) and I get funny
results. When I click on the Fx feature, I get the logical test and the
formula result=volatile. I'm trying to see if any one of the 3 have a
birthday in this month, or if the paretns have an anniversary in this month,
then show the words "this month" in my formula column (column a) but one
formula per family. Can you see what I'm doing wrong?
=IF(OR(MONTH(K13)=MONTH(NOW()),MONTH(L13)=MONTH(NOW()),MONTH(K14)=MONTH(NOW()),MONTH(K15)=MONTH(NOW())),"THIS MONTH","")
I'm using Excel 2003, windows XP if you needed this. It had been working
but going from Dec to Jan seems to have done something.