Foss,

If there is a reference date in a cell, (say A1), try:

=DATE(YEAR(A1),MONTH(A1)+(DAY(A1)20),20)-A1

If you want it to be independent of any reference cell then try:

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

in each case format the cell as General. If today's date is the 20th then
the formula will show zero

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"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