Hi Need Help with a complicated formula, dont knoe if its possible or not,
here it goes, I have the following cells laid out.

NAME A B C D E
F G
Above are all dates of beginning of weeks
Bill X x x
Ady x
Tom x

I need a formula that will return data of arrears paymeny e.g in weeks
(1week) (2weeks) and so on, so Ady and Tom would return data 2 weeks, is this
possible taking the current date for a reference?

Any Help???

Thanks a lot