Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 3rd 18, 02:20 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 14
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i convert a given # of days to Weeks, and days eric Excel Discussion (Misc queries) 1 November 20th 09 06:08 PM
Create Calculation to return number of weeks and days Lisa D Excel Worksheet Functions 8 December 30th 08 05:22 PM
how do i convert a number of days to years, months & days? SafetyLen Excel Discussion (Misc queries) 1 August 23rd 07 01:34 AM
Calculate Number of Months Weeks and Days Between Two Dates [email protected] Excel Worksheet Functions 4 September 22nd 06 01:47 AM
A number of days into weeks and days Robert Christie Excel Worksheet Functions 4 August 31st 05 03:23 AM


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017