I am not getting this right - All Help appreciated.
I want to divide if no of days in month is 28 and if not then the other criteria.



=K6/if(weeknum(today())=28,(Month(today())*12,(MONTH(T ODAY())-1)*12). I think am suppose to reference the 28days in a different way but I am unsure and dont know how. Thanks for the help!!

Hi
In your formula you don't obtain this but the "weeknum". The appropiate function should be DAY() instead of WEEKNUM()

Thanks, Whatsup - Help still needed

=K6/if(day(today())=28,(Month(today()),(MONTH(TODAY())-1)*12)). when I use this I get error. I see your point though but I still need help in making the formula work.

Check on the parentheses, there is something wrong, excel doesn't allow to enter the formular, but gives you some idea where to look.

Maybe that will work for you, but make sure that it meets your requirement:
=K6/IF(DAY(TODAY())=28,MONTH(TODAY()),(MONTH(TODAY())-1)*12)

Thanks Whatsup. This worked. Appreciate !!!
=k6/IF(DAY(TODAY())=28,MONTH(TODAY()),MONTH(TODAY())-1)*12

Surely the only time that is true is if the month is February in a non-leap year. For the most part, therefore, all you need test with whether the month is '2' and the year divided by '4' <> '0'. I know there are more sophisticated leap-year tests, but that will suffice for any year from 1901 to 2099, inclusive.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]