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!
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!