I would like to ask for someone advise who can help .
I am trying to set a leave formula as below. Total the whole year , leave allowance is 14 days.
But, it will be allocated by current month. If let's say, current month is *Jan* , then (14 days / 12 months )* month 1) , if Feb, if march , etc..
My below IF formula is working what I want. But, is there any better formula than this ?
IF(MONTH(TODAY())=1,(14/12),IF(MONTH(TODAY())=2,(14/12)*2,IF(MONTH(TODAY())=3,(14/12)*3,(IF(MONTH(TODAY())=4,(14/12)*4,(IF(MONTH(TODAY())=5,(14/12)*5,(IF(MONTH(TODAY())=6,(14/12)*6,(IF(MONTH(TODAY())=7,(14/12)*7,(IF(MONTH(TODAY())=8,(14/12)*8,(IF(MONTH(TODAY())=9,(14/12)*9,(IF(MONTH(TODAY())=10,(14/12)*10,(IF(MONTH(TODAY())=11,(14/12)*11,(IF(MONTH(TODAY())=12,(14/12)*12,"TO CHECK")))))))))))))))))))))
Thanks in advance
Bookmarks