excel vba - Find the number of days passed since January 1 of a particular year in vba -
i want find number of days passed since january 1 date provide.
example :
input - 12/01/2015 output - 12 input - 02/02/2015 output - 33 i need shortest possible way this. please tell me if there function available in vb this.
this should it: (input in cell c4 .. or replace c4 input)
=c4-date(year(c4)-1,12,31) (i looked @ days360() first, 1 isn't same math op needs, not choice there)
and yeah, no vba needed .. i'd stick normal formula if can ;) vba can bit slower sometimes, , harder maintain ...
Comments
Post a Comment