brunces
10-27-2006, 06:16 AM
Hi, friends.
Please, I'd like to know if the following is possible, without using tricks such as VLOOKUP or something.
1) Upper case for month
I have a date in cell A1: 01/01/2006
A1 format is defined this way: DD MMM YY
A1 value now is shown this way: 01 jan 06
But I want it to be shown this way: 01 JAN 06 (upper case for the month)
2) Upper case for weekday
I have a date in cell A1: 01/01/2006
I have a formula in cell B1: =A1
B1 format is defined this way: DDDD
B1 value now is shown this way: sunday
But I want it to be shown this way: SUNDAY (upper case for the weekday)
I have already solved these problems above using two tables and the MONTH, WEEKDAY and VLOOKUP functions.
Table MONTHS (1 = JAN, 2 = FEB, 3 = MAR, etc.)
Table WEEKDAYS (1 = SUN, 2 = MON, 3 = TUE, etc.)
But I'd like to know if there's another smoother way to get the same result, without using those tables and functions. Maybe there's a way to apply formats to the cells or maybe there are other functions I don't know which do what I want... whatever!
I have installed "Parry's Format Function Add-in". His functions work very well, but it seems they don't do what I need. Even if they did, there would be a problem: if I send my file to someone who doesn't use Parry's add-in, it won't work. :(
So, please, do you guys know if it's possible to do such a thing? If there's no way to do it, that's OK, just let me know it, please. :)
Thank you very much for your attention, friends.
Hugs,
Bruce
Please, I'd like to know if the following is possible, without using tricks such as VLOOKUP or something.
1) Upper case for month
I have a date in cell A1: 01/01/2006
A1 format is defined this way: DD MMM YY
A1 value now is shown this way: 01 jan 06
But I want it to be shown this way: 01 JAN 06 (upper case for the month)
2) Upper case for weekday
I have a date in cell A1: 01/01/2006
I have a formula in cell B1: =A1
B1 format is defined this way: DDDD
B1 value now is shown this way: sunday
But I want it to be shown this way: SUNDAY (upper case for the weekday)
I have already solved these problems above using two tables and the MONTH, WEEKDAY and VLOOKUP functions.
Table MONTHS (1 = JAN, 2 = FEB, 3 = MAR, etc.)
Table WEEKDAYS (1 = SUN, 2 = MON, 3 = TUE, etc.)
But I'd like to know if there's another smoother way to get the same result, without using those tables and functions. Maybe there's a way to apply formats to the cells or maybe there are other functions I don't know which do what I want... whatever!
I have installed "Parry's Format Function Add-in". His functions work very well, but it seems they don't do what I need. Even if they did, there would be a problem: if I send my file to someone who doesn't use Parry's add-in, it won't work. :(
So, please, do you guys know if it's possible to do such a thing? If there's no way to do it, that's OK, just let me know it, please. :)
Thank you very much for your attention, friends.
Hugs,
Bruce