Problems with If Date function

[Wolfgang17]

I'm trying to change the value of a cell according to the date in another cell. the date is formatted ddd mmm/dd/yyyy.
Iv'e tried many things, so far I have this that will return a value with out error, however it's the same value for regardless of change of date.
=IF("Week_Days">=DATE(2013,10,1),Data!B3,Data!B2)

I think the problem is with the Date format.

Any help would be appreciated.

Thanks

 

[Wolfgang17]

Hi Peter,

The spreadsheet is a time sheet. The dates (Week_Days) are days of the the week that I fill in through a macro at the beginning of the Payroll year, the start of which usually never falls on the same day, causing the date change between Sept 30 and Oct 1st to fall on different Cell ranges, and sometimes a different sheet. This year those dates fall on sheet 21, Cell "A30" (Sept 30th) and "A33" (Oct 1st). There is a annually Pay Rate Change on Oct 1st. The prior rate,(before Sept 30th=Data!B2, after Oct 1st +Data!B3.

I tried your suggestion. It will insert the value of Data!B2 into "R7" on all sheets . However, it will not change the value of "R7" to Data!B3 after October 1st, on sheet 21 and remaining 5 sheets. It remains the value of Data!B2.

Thanks

 

[Wolfgang17]

I was able to get your suggestion to work. For some reason i had to reverse the > sign after sheet 21.