Pulling a date in the current month

B

Brian

What I am trying to do is get my excel SS to pull any dates within the
current month for payments. I would likethe cell to say something like "if
cell A1 is in this month, display the date in B2, otherwise take the date
from B3".
I have come up with =IF(A1=DATE(YEAR(NOW()),MONTH(NOW()),),B2,B3), but I am
obviously having a problem without a day entered, it always gives the date in
B3. Any help would be appreciated. thx.
 
P

Peo Sjoblom

One way

=IF(MONTH(A1)=MONTH(TODAY()),B2,B3)


If you want to test for years as well

=IF(DATE(YEAR(A1),MONTH(A1),DAY(TODAY()))=TODAY(),B2,B3)
 
Top