Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to get the week number in excell from a cell with a date (dd/mm/aaaa),
but the first week of the year has 3 possiblilities, first week, with day nÂș 1, first week with at least 4 days of the new year or finally the first full week. How to do this in excell ? I tried with weeknum() but I can't choose the first week Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to get week number in month in excel ? | Charts and Charting in Excel | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
How do you change the date to a Number | Excel Discussion (Misc queries) | |||
Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
How can I create formula that turns a date into the week # in | Excel Discussion (Misc queries) |