Calendar Problem

[bodazx]

This challenge is a real whopper: not for the faint of heart

I work as a marketing intern at NBC Universal in <st1:city w:st="on"><st1lace w:st="on">London</st1lace></st1:city>. I was recently tasked with creating a calendar of the earliest international release dates for our DVD titles, adding 55 days to the <st1:country-region w:st="on"><st1lace w:st="on">US</st1lace></st1:country-region> release date given to us by our colonial counterparts.
<o> </o>
Because I was already given a previous year's spreadsheet to use as a template, I didn't bother too much to make any changes to the worksheet structure. The only formula I used in the worksheet was a simple = USdate +55 formula to calculate my int'l dates. I later realized this was inadequate, for a couple of reasons (reasons which, if you are on this board, you can probably infer).

My calendar looks like this:

Excel Workbook
	A	B	C	D	E	F	G	H
2	*	*	*	*	*	*	*	*
3	MARCH				APRIL
4	TITLE	EIRD *	US RELEASE DATE	AGENCY	TITLE	EIRD *	US RELEASE DATE	AGENCY
5	Law & Order S7	15-Mar	19-Jan	*	In Plain Sight	19-Apr	23-Feb	*
6	*	*	*	*	*	*	*	*
7	*	*	*	*	*	*	*	*
8	Monk S8	08-Mar	12-Jan	*	Kojak S2	26-Apr	02-Mar	*
9	*	*	*	*	*	*	*	*
10	*	*	*	*	*	*	*	*
11	Monk CS	08-Mar	12-Jan	*	Harry & The Hendersons	14-Jun	20-Apr	rights?
12	*	*	*	*	*	*	*	*
13	*	*	*	*	*	*	*	*
14	Murder She Wrote S11	29-Mar	02-Feb	*	*	*	*	*
15	*	*	*	*	*	*	*	*
16	*	*	*	*	*	*	*	*
17	Columbo 1991-1992	29-Mar	02-Feb	*	*	*	*	*
18	*	*	*	*	*	*	*	*
19	*	*	*	*	*	*	*	*
Int Schedule

I don't know why it is showing those *. Those cells are supposed to be blank.

Anyhow, my biggest complaint is whenever I update a US release date, if the change is great enough to affect the month of international release, I have to move the title to it's new month myself. I don't want to do that; I know there should be a way to conditionally format it, or do something else so that a title that should release in April will automatically move there on its own.

On it's own, solving this problem would be a tremendous help. If you can help me with an even larger challenge, that would be spectacular. About a week after I created the above calendar, I was forwarded another one from the guys over in the US. Their calendar had all the updated dates and titles for US release, so naturally I need to incorporate those into my cal to figure the int'l release. Unfortunately. their calendar was formatted completely differently:

Excel Workbook
	D	E	F	G	H	I	J	K
1	*	*	*	*		*	*	*
2	2/7 Superbowl * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 2/15 President's Day * * * * * * * * * * * * * * * * * * Late Feb. The Academy Awards		*	*	4/4 Easter * * * * * * * * * * * * * * * * * * * * * * * * * * * *4/22 Earth Day		5/9 Mother's Day * * * * * * * * * * * * * * * * * * * * * * * * * 5/31 Memorial Day	*
3	FEBRUARY	SRP	MARCH	SRP	APRIL	SRP	MAY	SRP
4	*	*	*	*	*	*	*	*
5	[2/2]	*	[3/2]	*	[4/6]	*	[5/4]	*
6	Tremors CS	29.98	Kojak S2	$49.98	NASCAR Gold	$14.98	Q2 TV Value Packs	$0.00
7	Murder She Wrote S11	$49.98	*	*	*	*	*	*
8	Inside the White House Collection	$29.98	*	*	*	*	*	*
9	*	*	*	*	*	*	*	*
10	*	*	[3/16 - 6/29] Q2 TV DVD TPR	*	*	*	*	*
11	[2/9]	*	[3/16]	*	[4/13]	*	[5/11]	*
12	Crusoe S1 Downsize	$26.98	Thriller 1960	$0.00	Battlestar Galactica S3 BD	$69.98	Hercules S1	$0.00
13	My Secret Identity	$34.98	*	*	Friday Night Lights S4	$29.98	Zena S1	$0.00
14	*	*	*	*	*	*	*	*
15	*	*	*	*	[4/20]	*	[5/18]	*
16	*	*	[3/16 - 5/11] SPRING BREAK TPR	*	Harry & the Hendersons S1	$39.98	L&O Criminal Intent S5	$59.98
17	*	*	*	*	*	*	SNL Digital Shorts	$19.98
18	*	*	*	*	*	*	Royal Pains S1	$59.98
19	[2/23]	*	*	*	*	*	*	*
20	In Plain Sight S2	$59.98	*	*	*	*	*	*
Development Calendar

The main purpose of my posting is, I want to know if there is a way that I can take the data I have recieved in the format of the US "Development Calendar" and easily bring it in to my "Int'l Schedule". Alternatively, if there is a better way to achieve the same objective (turning US release dates in to int'l release dates 55 days later), I would love to hear it. Also, I wouldn't be opposed to designing a new, more efficient template to be used by both countries. What is the best way I should do this?

Clearing both of the above issues up would be a great help. If you have the time, helping me solve a few other problems would be greately appreciated. When I created my formula in "Int'l Schedule" to calculate the EIRD (us release + 55), I want to drag this down to fill all the cells in the appropriate columns. However, I also want to leave 2 rows blank in between each title, and using the fill-down places the date Feb. 24 next to blank cells, which it reads as 00-Jan. This should be easy to fix, but using an =IF statement required that I at least instert a " " blank space as the negative argument, and I would rather leave the cells truly blank, than having them just appear "blank". To keep organized, I would like to be able to sort the data by day of month, but the blank rows I am intentionally leaving in between titles would be compromised. I would like to sort the data, but keep my blank rows intact.

Thank you for any and all help!