formula with divison by number of days in current month
Posted by Mark Henderson on January 31, 2002 3:43 PM
I have a formula whereby I wish to divide a column by the number of days in current month. I also have a formula I wish to do this for but diviing by number of days in previous month.
Please help!
Adieu
Mark
Posted by IML on January 31, 2002 3:46 PM
divisor
=DAY(DATE(YEAR(NOW()),MONTH(NOW()),0))
Posted by IML on January 31, 2002 3:53 PM
didn't mean to hit enter
divisor days in previous
=DAY(DATE(YEAR(NOW()),MONTH(NOW()),0))
divisor days in current
=DAY(DATE(YEAR(NOW()),MONTH(NOW())+1,0))
Posted by Mark Henderson on January 31, 2002 4:18 PM
Thank you :-)
