| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula
"Barbara" wrote in message
... "Barbara" wrote in message ... Hi, I have a column with a week number (15 for example) and i would like to return this number in the format of date. Better: it has to be the Friday of this week number. Example : Week Date 15 07/04/2006 Hope that somenone can help me. Tkanks, Barbara "Don Guillett" escreveu: try this. =DATE(2006,1,1)-WEEKDAY(DATE(2006,1,2))+B1*7 -- Don Guillett SalesAid Software Don, It gives an error on (2006,1,1). How can I fix it? What sort of error are you seeing? The formula seems to work for me. Note that it gives 14/4/06 for week 15, not 7/4/06 as you had suggested. [Week 1 gives 6/1/06] You may need to be careful about what sort of week numbers you are using, see: http://www.cpearson.com/excel/weeknum.htm -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Trending Formula Results by Date | Excel Worksheet Functions | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Hybrid Mode
