Multiplying/Dividing dates
- Thread starter PipBoy808
- Start date
SirJB7
Excel Rōnin
Hi, PipBoy808!
Why do you want to multiply or divide dates? There's no logical operation or process that involves that.
Regarding how Excel uses date and time values, you may perform a search within this forums and you'll get lots of links, this is one:
http://chandoo.org/forum/threads/length-of-time-not-time-of-day.12698/#post-74484
Regards!
Why do you want to multiply or divide dates? There's no logical operation or process that involves that.
Regarding how Excel uses date and time values, you may perform a search within this forums and you'll get lots of links, this is one:
http://chandoo.org/forum/threads/length-of-time-not-time-of-day.12698/#post-74484
Regards!
bobhc
Excel Ninja
Good day PipBoy808
The first date you are using is, (11 November 2013) which in excel world is 41589.00 and divided by 7 gives you 5941.29 which is 6 April 1916, Excel has done it this way because it does not understand why anybody would want to divide a date and has turned the dates in to their corresponding number to try and do what, for reasons it does not understand, you want to do.
It does not help to have parentheses around the date.
The first date you are using is, (11 November 2013) which in excel world is 41589.00 and divided by 7 gives you 5941.29 which is 6 April 1916, Excel has done it this way because it does not understand why anybody would want to divide a date and has turned the dates in to their corresponding number to try and do what, for reasons it does not understand, you want to do.
It does not help to have parentheses around the date.
SirJB7
Excel Rōnin
Hi, PipBoy808!
Be kind and do all us a favour... change your reading sources, or just switch to these website forums (but in this case please avoid my posts, instead I strongly recommend you those of b(ut)ob(ut)hc but after five o'clock British ceremony, which in his case it's called Carlsberg, malt, etc.).
Regards!
Be kind and do all us a favour... change your reading sources, or just switch to these website forums (but in this case please avoid my posts, instead I strongly recommend you those of b(ut)ob(ut)hc but after five o'clock British ceremony, which in his case it's called Carlsberg, malt, etc.).
Regards!
bobhc
Excel Ninja
Good evening SirJB7 how are you my friend.
After trying to divide the 11/11/2013 by 7(seconds! minutes!, hours!, days!, weeks!, Years!, who knows what seven could even be seven of nine (very nice lady)) I will be having a malt or two to let the grey cells be assimilated by the gold water of life from Scotland.
After trying to divide the 11/11/2013 by 7(seconds! minutes!, hours!, days!, weeks!, Years!, who knows what seven could even be seven of nine (very nice lady)) I will be having a malt or two to let the grey cells be assimilated by the gold water of life from Scotland.
SirJB7
Excel Rōnin
@b(ut)ob(ut)hc
Hi, my friend!
Good evening.
Hope you have just surfed and not dived into the Scotland's gold water rivers.
And as Marc L adopted once from one of my posts:
ReCarlsGardsBerg!
http://chandoo.org/forum/threads/move-files-from-folder.13204/#post-77825
Hi, my friend!
Good evening.
Hope you have just surfed and not dived into the Scotland's gold water rivers.
And as Marc L adopted once from one of my posts:
ReCarlsGardsBerg!
http://chandoo.org/forum/threads/move-files-from-folder.13204/#post-77825
Sajan
Excel Ninja
Hi Bob,
I can only speculate, but the VBA author might have been trying to determine the number of elapsed days between two dates, and used the number of weeks since 1/1/1900 as the basis for that calculation (i.e. number of weeks divided by 52 to get years, then the number of years times 365 to determine days, etc.!).
Of course, there are many simpler approaches for calculating elapsed days, and as such, I am not sure why anyone would use such an approach. It could be that the VBA author did not want his "secrets" to be revealed to any casual reader of the code! Or, it could be that the VBA author did not know what he was doing. Either way, it adds to the enjoyment of those reading his code (which could have been his/her motive!)
Cheers,
Sajan.
I can only speculate, but the VBA author might have been trying to determine the number of elapsed days between two dates, and used the number of weeks since 1/1/1900 as the basis for that calculation (i.e. number of weeks divided by 52 to get years, then the number of years times 365 to determine days, etc.!).
Of course, there are many simpler approaches for calculating elapsed days, and as such, I am not sure why anyone would use such an approach. It could be that the VBA author did not want his "secrets" to be revealed to any casual reader of the code! Or, it could be that the VBA author did not know what he was doing. Either way, it adds to the enjoyment of those reading his code (which could have been his/her motive!)
Cheers,
Sajan.