Wolfgang17
Board Regular
- Joined
- Nov 8, 2010
- Messages
- 60
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
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