Microsoft Office Forums - View Single Post - [Solved] Formula to divide if no of days in month is 28

Thread: [Solved] Formula to divide if no of days in month is 28

View Single Post

Old

06-25-2014, 08:05 PM

shilabrow

shilabrow is offline

shilabrow uses Windows Vista

Windows Vista shilabrow uses Office 2007

shilabrow uses Office 2007

Office 2007

Advanced Beginner

The original poster

Join Date: Apr 2014

Posts: 45

shilabrow is on a distinguished road

Default

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

Reply With Quote