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. |
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. |
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","") |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com