Forum Discussion
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!
2 Replies
- Riny_van_EekelenPlatinum Contributor
- SadafSinghCopper Contributor
it works! thank you so much!