D
David B.
There are certain items that need to be tracked by
month. I would like to reference just the month portion
of =today() and compare it to the month entered for the
item to be tracked. Eg: If today is October 5th, and
there are two items to be tracked for October only.
A1 is =today()(formated to mmm).
A2=training B2=Oct(entered by person) C2 in formula "yes"
or "No")
*(i just want a way to say if(a1=b2,"Yes","No")
I thought that this would work, but all I get is "No". I
tried to make it all numbers but that gave me nothing.
eg: A1=today(), (formated to mm)
A2=Item, B2=10, C2=(yes or no). But when I change B2 to
date (formatted to mmm) I get Jan. I hope I asked this
right. Thanks for your time.
month. I would like to reference just the month portion
of =today() and compare it to the month entered for the
item to be tracked. Eg: If today is October 5th, and
there are two items to be tracked for October only.
A1 is =today()(formated to mmm).
A2=training B2=Oct(entered by person) C2 in formula "yes"
or "No")
*(i just want a way to say if(a1=b2,"Yes","No")
I thought that this would work, but all I get is "No". I
tried to make it all numbers but that gave me nothing.
eg: A1=today(), (formated to mm)
A2=Item, B2=10, C2=(yes or no). But when I change B2 to
date (formatted to mmm) I get Jan. I hope I asked this
right. Thanks for your time.