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.