Week Ending data

T

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.
 
K

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top