#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert regular Date to Week Ending or Week Beginning Dates Sam H Excel Discussion (Misc queries) 5 April 3rd 23 04:39 PM
week ending peter Excel Worksheet Functions 4 April 3rd 08 03:31 AM
Week Ending Reports jmedwards2007 Excel Discussion (Misc queries) 1 March 5th 07 10:25 PM
AVG row of data by Week ending JmyCrikitt Excel Discussion (Misc queries) 4 January 25th 07 07:28 AM
Week ending [email protected] Excel Worksheet Functions 3 November 1st 05 05:52 PM


All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"