Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data applied to specific day of month
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 |
#2
|
|||
|
|||
This formula works by testing each date to see if the date is a Sunday,
and then tests to see if that Sunday's calendar day is less than 8. (8 is the limit because a Sunday that falls on the first, day 1, won't appear again until day 8. If the first of the month is a Wednesday, the first Sunday is the 5th of the month; 5 is less than 8.) =IF(WEEKDAY(A1,1)=1,IF(DAY(A1)<8,"John Doe",""),"") |
#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 |
Reply |
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 |