Convert Date to Excel Date - Moment.js

Convert Date to Excel Date - Moment.js

by wittich

HTML

<script src="//cdnjs.cloudflare.com/ajax/libs/moment.js/2.2.1/moment.min.js"></script>
Date <input id="in" placeholder="27.06.2018" value=""><br />
<br />
Excel <input id="res">

JavaScript

$( "#in" ).change(function() {
	$('#res').val((moment.utc($("#in").val(),"DD.MM.YYYY").unix() ) / 86400 +	25569);
});
$('#in').val('27.06.2018');
$('#in').trigger("change");