| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Earned Vacation time Formula
I think i have the formula down, but i keep receiving error messages. i think
it is a bracket problem, but no one here understands enough to help. I've been looking at it for hours now and think i've just lost perspective. =if((today()=Date(2009,01,01)),"",if(today()<=dat e(2007,12,31)),"",IF(TODAY()<=(DATE(2008,12,31))), ((TODAY()-(DATE(2008,1,1)))*0.22),IF(TODAY()=(DATE(2008,12, 31))),((TODAY()-(DATE(2008,1,1)))*0.22),0)) i was hoping that if the current date was outside the parameters it would simply show up blank, otherwise it would process the formula regularly showing {number of days this year} * 0.22. Excel-03 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Earned Vacation time Formula
Not very sure, maybe you meant this:
=IF(YEAR(TODAY())<2008,"",IF(TODAY()<=DATE(2008,1 2,31),TODAY()-DATE(2008,1,1)*0.22,0)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Savage666" wrote: I think i have the formula down, but i keep receiving error messages. i think it is a bracket problem, but no one here understands enough to help. I've been looking at it for hours now and think i've just lost perspective. =if((today()=Date(2009,01,01)),"",if(today()<=dat e(2007,12,31)),"",IF(TODAY()<=(DATE(2008,12,31))), ((TODAY()-(DATE(2008,1,1)))*0.22),IF(TODAY()=(DATE(2008,12, 31))),((TODAY()-(DATE(2008,1,1)))*0.22),0)) i was hoping that if the current date was outside the parameters it would simply show up blank, otherwise it would process the formula regularly showing {number of days this year} * 0.22. Excel-03 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Earned Vacation time Formula
Savage --
Another similar route: =IF(YEAR(TODAY())=2008,(TODAY()-DATE(2008,1,1))*0.22,"") For May 28, returns 32.56. HTH "Savage666" wrote: I think i have the formula down, but i keep receiving error messages. i think it is a bracket problem, but no one here understands enough to help. I've been looking at it for hours now and think i've just lost perspective. =if((today()=Date(2009,01,01)),"",if(today()<=dat e(2007,12,31)),"",IF(TODAY()<=(DATE(2008,12,31))), ((TODAY()-(DATE(2008,1,1)))*0.22),IF(TODAY()=(DATE(2008,12, 31))),((TODAY()-(DATE(2008,1,1)))*0.22),0)) i was hoping that if the current date was outside the parameters it would simply show up blank, otherwise it would process the formula regularly showing {number of days this year} * 0.22. Excel-03 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
| Accruing Vacation Time as Time Passes | Excel Worksheet Functions | |||
| Detailed Time Sheet (overtime, comp time, vacation used) | New Users to Excel | |||
| converting time worked to dollars earned. | New Users to Excel | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
Linear Mode
