Forum Discussion

SadafSingh's avatar
SadafSingh
Copper Contributor
Apr 15, 2020

Need help with a excel formula

Hey guys, sorry if i am posting this in the wrong space!

 

I need a formula to put into excel where if there is a value in there, i want the month from that value, and if that cell is blank, then i dont want any results.

 

Eg. Cell E1 = 28/03/2020 17:54

Cell E2 = blank

Currently, i have formula set up just to give me month for E1 which is = TEXT(E1,"mmmm") = March

But when i drag the formula down, there are some fields where no date is populated, so for some reason, the same formula for a blank cell gives me January as a result. 

 

I need a formula that does two things:

1) If there is data in that cell, then give me the month

2)If there is no data in that cell, then give result as blank instead of January.

 

Hoping this makes sense!

Resources