Thanks a lot Barb, Great stuff.


Regards,

Mark

"Barb Reinhardt" wrote:

Format it as NUMBER.

"santaviga" wrote:

Hi, Sorry this is returning a date and time in 1900 I need it to return data
1 WEEK or 2 WEEK or 3 WEEK depening on the x's in the information according
to week commencing dates.

Mark

"Barb Reinhardt" wrote:

Let's say that your dates are in column 1.

Let's also say that Bill's information is in column 3 (specifically cells
B3:H3)

Try this formula:

=INT(TODAY()-INDEX($1:$1,1,MATCH("x",A3:H3)))/7

"santaviga" wrote:

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