Hi

I’m looking for a formula that will calculate the number of days left in a month when the formula looks at any day in the month.

For example – if A1 = 2006/05/14 then the formula in A2 that look at A1 must give the answer 17

I tried every thing I know of but nothing wants to work.

Thanks for you help

Neels

I’m looking for a formula that will calculate the number of days left in a month when the formula looks at any day in the month.

For example – if A1 = 2006/05/14 then the formula in A2 that look at A1 must give the answer 17

I tried every thing I know of but nothing wants to work.

Thanks for you help

Neels

## Comment