Thread: excel vba number of days expressed in weeks and days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] d.e.lindstrom@gmail.com is offline
external usenet poster
  
Posts: 18
Default excel vba number of days expressed in weeks and days
The output of this line of code:

in " & (dEventDate - dEmailDate) & " days"

would be:

"in 36 days".

How can I get it to read " in 5 weeks and 1 day"?

Reply With QuoteReply With Quote