| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Week number date formula
Hi
I'm trying to write a formula to show the date where 20/03/2008 would show as W3Thur and 31/03/08 would show as W5Mon and 01/04/2008 would show as W1Tue. I have A1= 20/03/2008 and B1= "W"&weeknum(workday(a1,0),1)/4&text (weekday(a1),"ddd") It currently works fine if the week number divides by 4 as a whole number, but I don't want the fractions! Thanks Wendy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return week number from date? | Excel Worksheet Functions | |||
| How to return week number from date? | Excel Worksheet Functions | |||
| How to display date as week number | Excel Discussion (Misc queries) | |||
| How can I calculate the week number from a date, eg 21/06/05 = 26 | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Threaded Mode
