How do I get it to return a blank value if there is no date in the field?

System

This discussion was created from comments split from: How to extract just the month name from a date.

VBAGuru

Add to the start of your formula:

If([Date Charged]@row="","",

then you would need one more ) at the end

Scott Peloquin

How do I get it to return a blank value if there is no date in the field? I'm using the above formula:

=IF(MONTH([Date Charged]@row ),MONTH([Date Charged]@row )) = 1, "January", IF(MONTH([Date Charged]@row ) = 2, "February", IF(MONTH([Date Charged]@row ) = 3, "March", IF(MONTH([Date Charged]@row ) = 4, "April", IF(MONTH([Date Charged]@row ) = 5, "May", IF(MONTH([Date Charged]@row ) = 6, "June", IF(MONTH([Date Charged]@row ) = 7, "July", IF(MONTH([Date Charged]@row ) = 8, "August", IF(MONTH([Date Charged]@row ) = 9, "September", IF(MONTH([Date Charged]@row ) = 10, "October", IF(MONTH([Date Charged]@row ) = 11, "November", IF(MONTH([Date Charged]@row ) = 12, "December"))))))))))))

VBAGuru

Add to the start of your formula:

If([Date Charged]@row="","",

then you would need one more ) at the end

Genevieve P.

Hi @Scott Peloquin

Just sending you an @mention in case you missed the comment above!

@VBAGuru's solution is what I would suggest as well. 🙂

Scott Peloquin

That worked perfectly. I was trying to use ISBLANK but that obviously was not right. Thank you.