Hi. I am looking for a formula which will display the Month in the format mmm (jan) in one cell, based on another cell which has the formula today().
So, right now, in a2, I have the formula today(), and in a1 I have the formula month(a2). But, no matter what I do, it produces "Jan", even though it is actually May.
Help!
Bookmarks