![]() |
|
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
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) |
#3
|
|||
|
|||
![]()
Thanks Whatsup. This worked. Appreciate !!!
=k6/IF(DAY(TODAY())=28,MONTH(TODAY()),MONTH(TODAY())-1)*12 |
![]() |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
vthomeschoolmom | Excel | 1 | 04-18-2012 02:29 PM |