Thread: any way to tell the last day of the month? when the month is a var?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jim sturtz jim sturtz is offline
external usenet poster
  
Posts: 11
Default any way to tell the last day of the month? when the month is a var?

ie, if a a1 has 10/9/6 as a date, then month will give me the numeric month
into say a2, need to now how to find 31 into a3 or
" 4/6/6 "
30 "

thanks.

jim


Reply With QuoteReply With Quote