| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert week number into calendar month?
I'm attempting to calculate a manufacture date from a serial number. The
serial number has the year, week number, and day of the week. For example, 3447 would be decoded like this: 3=year(2003), 44=week number, and 7=weekday(Saturday). Basically, the year and weekday are easy to place within a formula. It's calculating the month from the week number that I'm having the problem with. Anyone have any idea as to how I might handle this situation? Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get week number in month in excel ? | Charts and Charting in Excel | |||
| How do I convert a serial number to the month, day, and year in E. | Excel Discussion (Misc queries) | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
Threaded Mode
