If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
#2
|
|||
|
|||
Convert weekno to a date
See if this is something you can work with:
A4: 2 (The week number) A5: 2005 (The year..you didn't mention if the formula might apply to other years) B7: =DATE(A5,1,CHOOSE(WEEKDAY(DATE(A5,1,1),2),5,4,3,2, 1,7,6)+(A4-1)*7) Does that help? •••••••••• Regards, Ron "Box666" wrote: 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert Julian date to real date | Carlo | Running & Setting Up Queries | 4 | June 9th, 2005 08:38 PM |
date ranges from a calculated date field | John Feeley | Running & Setting Up Queries | 1 | May 26th, 2005 06:53 AM |
how do I convert a UK date to a US date in excel? | sls | General Discussion | 1 | May 17th, 2005 09:12 PM |
Date value, convert from text to date type | Serg | Running & Setting Up Queries | 3 | September 2nd, 2004 05:43 PM |
more dates!!! | brigid | Running & Setting Up Queries | 6 | May 26th, 2004 10:59 AM |