Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Week Ending data
Hello,
I have a spreadsheet as follows: Column A has dates for all the days in the calendar going all the way back to many years. Column B has numerical data associated with each day. Some days may not have a data due to a holiday or similar event. The cells when the data is not available read "ND". Column C lists all days which are week ending days; typically Fridays; as "WE". However if the last Friday was a "ND", then the cell in column C against the last Thursday should read "WE" Please advise how I can achieve this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Week Ending data
http://www.contextures.com/tiptech.html If this post helps click Yes --------------- Jacob Skaria "Tigerxxx" wrote: Hello, I have a spreadsheet as follows: Column A has dates for all the days in the calendar going all the way back to many years. Column B has numerical data associated with each day. Some days may not have a data due to a holiday or similar event. The cells when the data is not available read "ND". Column C lists all days which are week ending days; typically Fridays; as "WE". However if the last Friday was a "ND", then the cell in column C against the last Thursday should read "WE" Please advise how I can achieve this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Week Ending data
On 17 June, 09:46, Tigerxxx
wrote: Hello, I have a spreadsheet as follows: Column A has dates for all the days in the calendar going all the way back to many years. Column B has numerical data associated with each day. Some days may not have a data due to a holiday or similar event. The cells when the data is not available read "ND". Column C lists all days which are week ending days; typically Fridays; as "WE". However if the last Friday was a "ND", then the cell in column C against the last Thursday should read "WE" Please advise how I can achieve this. You could use the WEEKDAY function in column D to identify which dates are Fridays, and then a formula like IF(AND(D2=6,B2="ND"),"WE","") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
week ending | Excel Worksheet Functions | |||
Week Ending Reports | Excel Discussion (Misc queries) | |||
AVG row of data by Week ending | Excel Discussion (Misc queries) | |||
Week ending | Excel Worksheet Functions |