Find Us On: Facebook Twitter Rss Feed Blog
Need To Register? Sign Up Login

Convert DMY to Excel Serial Number

aalvarez
aalvarez 


Develop a code capable of converting DMY into Excel Serial number. Example January 15, 1900 is Excel #15. Attachments
Tags
Clarifications

Answers

Answer

mariobeka
mariobeka 



Converter of DMY to Excel Serial Code Attachments
DMYConverter.java (1 K) Download Preview
== 02 && nYear==1900) return 60; // DMY to Modified Julian calculatie with an extra substraction of 2415019. long nSerialDate = (int)((( 1461 * ( nYear + 4800 + (( nMonth - 14 ) / 12) ) ) / 4) + (( 367 * ( nMonth - 2 -

Output.png (12 K) Download Preview

Screenshots
Screenshot
Purchase Answer