Week Ending data

[Tigerxxx]

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.

 

[Jacob Skaria]

http://www.contextures.com/tiptech.html

If this post helps click Yes

 

[Khuli]

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","")