Pulling a date in the current month

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.

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)


--

Regards,

Peo Sjoblom

"Brian" <Brian@discussions.microsoft.com> wrote in message
news:84700D39-9EEF-4F9B-BEC8-688BBF652BED@microsoft.com...
> 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.

One more:

=IF(text(a1,"yyyymm")=text(TODAY(),"yyyymm"),B2,B3)

Brian wrote:
>
> 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.

--

Dave Peterson