| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005?
How can we get the date of the Monday of Week 44 of Year 2005 using Excel function/s ? |
|
#2
|
|||
|
|||
|
For the week beginning on Sunday...
=TEXT(A1,"dddd")&" of Week "&WEEKNUM(A1)&" of Year "&YEAR(A1) For the week beginning on Monday... =TEXT(A1,"dddd")&" of Week "&WEEKNUM(A1,2)&" of Year "&YEAR(A1) Hope this helps! In article .com, "datt350" wrote: How can we get the date of the Monday of Week 44 of Year 2005 using Excel function/s ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| Microsoft Excel tries to load front page on opening | Excel Discussion (Misc queries) | |||
| Can Excel notify me when a date is due? | Excel Discussion (Misc queries) | |||
| How do I enter the date last modified in the footer of an Excel d. | Excel Discussion (Misc queries) | |||
Hybrid Mode
