Hi there Peo,

Thanks very much, that's just what I was after!

Cheers,
Foss


"Peo Sjoblom" wrote:

One way

=DATE(YEAR(TODAY()),MONTH(TODAY())+(DAY(TODAY())2 0),20)-TODAY()

--
Regards,

Peo Sjoblom

(No private emails please)


"Foss" wrote in message
...
Hi there,

I need to write a formula that tells me the amount of weeks and days
before
the 20th of next month.

Has anyone got such a formula they could pass me? I had a quick look but
it's too hot for my poor little mind to function today!

Any pointers much appreciated..

Cheers,
Foss