Excel question

[tiermat]

I have a excel spreadsheet that contains a load of figures and some dates.

I need to, in a seperate column, compare two dates (col F and col J), and if the date in col J is more than 7 days after the date in col F then indicate so, if not then leave the cell blank.  I need to do this for each of 17 rows (which is obviously an easy copy 'n' paste)

I have no idea where to start with writing the macro, any ideas?

[peterh]

Put a formula in an empty cell in the row (example is for row 2):

=if(J2-F2>7, "late","")

This will show 'late' if the dates differ by more than 7 days, otherwise it will be blank.

[tiermat]

Cool, that worked, thanks...

yACF FTW again