| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
On Wed, 2 Mar 2005 10:21:20 -0500, "Daniel.M"
wrote: Thanks for the credit. Here's an even shorter version: =4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-DOW)) DOW: 1:Monday 7:Sunday Definitely a keeper! --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of days in given month? | Excel Worksheet Functions | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
| calculate month from week number | Excel Worksheet Functions | |||
| Total number of each month in a column of dates | Excel Worksheet Functions | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Hybrid Mode
