I need a formula to calculate the number of days between NOW() and the first day of the next month, ie, 01/12/05 = 1 day, today. Is there a way to have excel do this as months vary in length. Thanks in advance.
Thanks for the speedy reply, but that formula returns a #NAME?. I think this requires an add-in. The problem is that other users will be using this workbook who do not have the add-in, as I guess it is machine specific and not packaged into the worksheet?