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

Popular posts from this blog

How to provide Authorization & Authentication using Asp.net, C#? -

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

How to use Authorization & Authentication in Asp.net, C#? -