Pulling a date in the current month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Days in a month as of today 2
Comparison of columns using Conditional Formatting 3
excel "IF" function... is this possible ? 0
Getting 'Dates' 4
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
IF(AND(OR function returns #VALUE! error 3
Can I use the NOW() function in a formula? 2

Back
Top