Prev: How do I preserve font/size when sending text to a different cell
Next: Convert Week number into Month
From: KT on 27 May 2010 19:48 I have a worksheet with year and week number and want to use a funtion to convert these two values into the descriptive month. Some weeks cross months, but that's okay, I just need one value returned per record. It could be the month that the first day of each week falls in. I'm using Excel 2003. Thanks! |