View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ricky Ricky is offline
external usenet poster
 
Posts: 30
Default Days remaining in the month

Can anyone suggest how I can have the number of days remaining in the
month, from a date entered in A1, displayed as a numeric, ie:

Cell A1 has "20/01/09"

I would like a formula to return the number of days remaining in the
month, in this case "11" days (31 less 20).

Thanks - Ricky