IF Statement Question dealing with Dates

**lilsnoop** · 05-09-2007, 08:39 PM

Does anyone know if I can use an IF statement to deal with dates? I need to use an IF statement to use one wage before a certain date and another wage if after a different date. i.e. anything before April 1st is one wage and employees get a raise afterwards which will affect my spreadsheet and I need it to use the raise formula if after April 1st. I hope this makes sense.
I'm using Excel 2007 if that would help any...

Thanks in advance!

**tuph** · 05-09-2007, 10:03 PM

Assuming your data is in columns A & B, like this:

oldwage newwage
5 10

try this in column C:

=IF(TODAY()<1/4/7,A2,B2)

**Dav** · 05-10-2007, 05:22 AM

It is not clear in which year 1/4/7 falls if it is a or b

=IF(A1<39173,1,2)

if 1 is the first rate and 2 is the seond rate and the date to be evaluated is in a1.

39173 is the 1st of April 2007 as a number

the < may need to be <= depending which year the 1st april is in

Regards

Dav

**lilsnoop** · 05-10-2007, 06:52 AM

I'm attaching a very simple test file that will hopefully show what I'm trying to accomplish. It has comment messages as well. Ideally each sheet will reflect an individual employee, who will be assigned their own ID#. The overtime issues is split into two columns in the mere chance I have two employees who want to split an eight hour day resulting from a particular sheet (i.e.) employee who called in sick, etc. In this example sheet1 represents an employee who called in sick and I'm entering data for the employees who our covering the shift. Unfortunately due to size restraints I can only make this a 2page sample. I really need the date column(A) to affect the pay scale for the individual employees that our covering the shift hours. That is why I needed to have the ID system. I'm finding it very difficult for the date issue to cover the varying pay rates for the various sheets I will have. At this point I can't even get it to do sheet2? Any suggestions?? Thanks for any/all input!

**Dav** · 05-11-2007, 06:26 AM

Perhaps you could add more sheets, as delete a few lines at the bottom makes you file much smaller.

If you take care naming your sheets exactly the same as the staff names in the lookup table this may work. If you has used the sheets named as sheet1 to sheet99 relating to the employees the formula would have been simpler.

regards

Dav