| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
If the date is in A1, try:
=IF(DAY(A1)<8,"1",IF(DAY(A1)<15,"2",IF(DAY(A1)<22, "3",IF(DAY(A1)<29,"4","5")))) and replace the "1", etc with the appropriate name. Fill the dates down in column A and then copy the formulae in column B. -Ray "LGW" wrote: I have a list of Sundays in the year. I need to insert a name in next column. Some people have requested a specific Sunday (ie: First Sunday). So if column A holds the days, I need a formula to insert the names in column B based upon the Nth day that it happens to be. Looks like: Sunday, January 01, 2006 John Doe -- LGW ------------------------------------------------------------------------ LGW's Profile: http://www.excelforum.com/member.php...o&userid=28046 View this thread: http://www.excelforum.com/showthread...hreadid=475517 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing data per month & year for comparison | Excel Discussion (Misc queries) | |||
| Referencing data in different worksheet based on month name | Excel Worksheet Functions | |||
| import data to specific columns | Excel Discussion (Misc queries) | |||
| Autofill data in specific blank cells | Excel Worksheet Functions | |||
| Group by Month when no data | Excel Worksheet Functions | |||
Threaded Mode
