Posted by Zoe Reyes on January 24, 2002 8:23 AM
I'm pretty "green" in Excel as you are about to find out, and would appreciate any assistance in solving the following:
I'm working on a spredsheet that has fiscal years in a row as text as follows: "FY02", FY03", etc., and in another row, months as follows: "JUL HRS", "SEP HRS", and so on.
I need to be able to return the last day of the month for each month, for instance, FY02 - JULHRS => Jul-31-2002.
Any advice on how to go about it will be kindly appreciated.