Tips and Tricks for Using 3D Object Converter 5.30: Batch Conversion, Preview, Properties, and More
Hi, I am trying to find a way to calculate how many days are in the current month. So if the current date is April 10th 2014, this is the number of days in April for that year (without floating point numbers and without setting up a cell formula, just using the function of Month(today()). Thanks,
3d object converter 5.30 serial number
Hi, Unfortunately, Excel does not have a function that will add up all the seconds and then convert to the next whole number. You could use a UDF (User defined function). This will be a collection of VBA code. See if you can implement a function that will take a series of seconds (hh:mm:ss) and convert to the next whole number (the details of such a function is given here: http://www.excelcode.com/vba-excel/how-to-add-up-all-data-in-excel/) In that function, you can perform the calculations for the conversion from seconds to minutes, and from minutes to hours and so on. This time conversion can be completed in several steps. If you would like to get acquainted with how to do such calculations, please join us in our 3dexcel forum (http://www.3dexcel.org/forum/) where you will find many free videos and documentations about VBA.
Hey, I found a formula that calculates the number of days by using the hour by minute type method. =DATE(YEAR(A1);MONTH(A1;2);DAY(A1;2);1) =DATE(YEAR(A1);MONTH(A1;3);DAY(A1;2);2) =DATE(YEAR(A1);MONTH(A1;4);DAY(A1;2);3) ... ... ... ... =DATE(YEAR(A1);MONTH(A1;2);DAY(A1;2);24) Then, =60*60*60*24 =60*60*60*24 hours in a day =60*60*24 minutes in a hour =60*24 seconds in a minute =24*60 seconds in a hour =24*60 minutes in a day =24*60 hours in a week =7*24 days in a month =30*24 in a year Days in a week, we count a week starting with Sunday as the first day of week, so, the formula will be =DATE(YEAR(A1);MONTH(A1;3);DAY(A1;2);DAYS(A1;6;-3)) Sorry my explanation is not so clear, but, I am sure this is what you want.