| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert weekno to a date
I have a week no. (say week 2) in cell A4 and I want to convert that
to the Fiday of that week (in cell B7) in the format Fri 14th Jan 2005. Could anybody tell me how to achieve this please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a list of date of births into age in Excel? | Excel Worksheet Functions | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| How to convert DATE and TIME to text | Excel Worksheet Functions | |||
| Convert Date to MMYY | Excel Discussion (Misc queries) | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Threaded Mode
