Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi everyone,
I have in A1:Ax dates, formatted as "mm.dd.yyy", i need a formula that will tell me which day is that day, but in the known way like monday, tuesday,.... i know how to do this, i want to get something like this: FIRST Monday of December 2008, like getting the date and telling me which monday of this month is it, or say second saturday, fourth wednesday, such things i mean. i know how to get the last part (Monday of December 2008) but i have no clue on how will i check which one is it? like first second, third? how can i do this? Thanks in advance for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |