#1
|
|||
|
|||
Formula to divide if no of days in month is 28
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!! Last edited by shilabrow; 06-25-2014 at 08:14 AM. |
#2
|
|||
|
|||
Hi
Quote:
|
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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) |
#5
|
|||
|
|||
Thanks Whatsup. This worked. Appreciate !!!
=k6/IF(DAY(TODAY())=28,MONTH(TODAY()),MONTH(TODAY())-1)*12 |
#6
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Formula Showing Revenue Recognition Based on Days and Months | stratcat | Excel | 4 | 03-16-2014 10:09 AM |
Formula To Calculate Countdown Days To Project Completion | Catherine | Project | 1 | 02-19-2014 11:15 AM |
Formula for week days only | gbaker | Excel | 5 | 02-15-2014 01:07 AM |
Formula to count entries as per month, year and submission wise from different sheets | pinkacidpunk | Excel | 1 | 05-28-2013 08:26 AM |
formula divide by serio error | vthomeschoolmom | Excel | 1 | 04-18-2012 02:29 PM |