I am racking my brains but can't figure out why the formula is not working for Aug thru Nov. I used Text(A2, "mmm"). Any ideas?
I am racking my brains but can't figure out why the formula is not working for Aug thru Nov. I used Text(A2, "mmm"). Any ideas?
Try =DATE(YEAR(TODAY()),Table1[@[Data.DOB (Month)]],1) pulled down and formatted as "mmm" or insert it in the TEXT function
I hope this will explain why:
AliGW on MS365 Insider (Windows) 32 bit
A B C D E F 1Data.DOB (Month) 2 7Jan 07/01/1900Jul =TEXT(DATE(2021,Table1[@[Data.DOB (Month)]],1),"mmm") 3 8Jan 08/01/1900Aug 4 9Jan 09/01/1900Sep 5 10Jan 10/01/1900Oct 6 11Jan 11/01/1900Nov
Sheet: Sheet1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
thanks....worked
To add my two cents, to Excel 1 is 01/01/1900, so 7 is 07/01/1900 (d/m/y). the MONTH function will always return 1 for numbers up to 31, 2 from 32, to 60 , etc.. ( yes, XL made the mistake of thinking 1900 was a leap year)
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks