• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Date Range Look up

Effendi

New Member
Hope someone can help.

I have 2 date columns.
The columns have a start and finish date .
The dates span 2005-2010.
The rest of the columns are blank columns for 2005 to 2010.

What I would like to ask the experts here is how I could indicate in the blank columns whether it spans a particular year. For example row 1 has a date range of 2005-2008 and I would like to indicate by a yes in the 2005, 2006, 2007, 2008 year columns.

A sample file is attached to illustrate.

Hope I was clear.
Any help would be super!
 

Attachments

  • Book1.xlsx
    8.2 KB · Views: 3
Back
Top