Issues modifying formula

Hello everyone,

So, I have some VBA code that I am trying to use and I can't seem to get the criteria situated correctly for it to work correctly. Let me explain what I am trying to do first...I have 4 columns with dates...for the sake of argument lets say they are in columns A, B, C, and D, but not every cell in columns C or D have data points. So, what I want this code to do is that if the cell is column D is empty then use one specific formula but if it is not empty then is use a different formula. So for example, if D5 had a date in it then the formula in E5 would be

Formula:

Please Login or Register  to view this content.

and then go to the next cell down in column E until no more rows of data. Then if on row 7 and D7 was empty then the formula in E7 would be

Formula:

Please Login or Register  to view this content.

Here is the code I have been trying to modify but just can't figure it out...

Please Login or Register  to view this content.

Any ideas or solutions?

Thanks!!!!

This still is not referencing the correct cell to determine which formula to use. It seems to still check whether the cell where the formula is going is empty or not.

Ok...I have included a sample of the data that I am working with for reference. In Column "T" is where I want the formula to be entered. Again...I want the code to look in Column "Q" and if this cell is empty then in Column "T", the formula entered should be

Formula:

Please Login or Register  to view this content.

. If that cell is not empty then the formula should be

Formula:

Please Login or Register  to view this content.

. Then this repeats for each cell in Column "T" that has data.

That worked beautifully...thanks!!!