#### willow1985

##### Active Member

- Joined
- Jul 24, 2019

- Messages
- 424

- Office Version
- 2019

- Platform
- Windows

Hello,

I have a column that has a list of "0" and dates.

I am looking for a formula that will return the Month name on any cell that does not contain the text "0" and if it has a "0" return a blank cell.

Here is the formula I wrote but unfortunately it does not seem to be working.

=IF(M2<>"0",TEXT(M2,"mmmm"),"")

Data looks like this:

0

2019-09-23

2019-09-02

2019-08-05

0

2018-05-07

The 0 is "number stored as text".

If I change the formula to: =IF(M2<>0,TEXT(M2,"mmmm"),""), it returns the month name as January for every cell and if I have it as "0" it returns everything as blank.

Hope someone can help me with this

Thank you

Carla

I have a column that has a list of "0" and dates.

I am looking for a formula that will return the Month name on any cell that does not contain the text "0" and if it has a "0" return a blank cell.

Here is the formula I wrote but unfortunately it does not seem to be working.

=IF(M2<>"0",TEXT(M2,"mmmm"),"")

Data looks like this:

0

2019-09-23

2019-09-02

2019-08-05

0

2018-05-07

The 0 is "number stored as text".

If I change the formula to: =IF(M2<>0,TEXT(M2,"mmmm"),""), it returns the month name as January for every cell and if I have it as "0" it returns everything as blank.

Hope someone can help me with this

Thank you

Carla

Last edited: