Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Recogniziting Dates in an IF function?
I want to set an IF function based on date.
The premise is that bonus pay is paid only if an employee works up to or after a specific date. If the end date of the employee is before DATEX, then do the calcuation, if not, the calculation is irrelevant. It looks like this: =IF(B3DATE,(T5*U8)/12,"0") Except the function doesn't use the date in the way I intend. Is there a different function I should be using and how? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions | |||
if function with dates | Excel Discussion (Misc queries) |