stevenmcheerful
New Member
- Joined
- Apr 16, 2002
- Messages
- 20
This does not seem to work
IF( A2 + monitor!B2 >= Today(),calc!V2,#N/A)
I want to take the value in WKS monitor cell B2 (say it is 3) and add it to whatever date is in ActiveSheet.A2
If that adds up being equal to or greater than today's date, I want to pull in a value
from another sheet. If not, display #N/A
instead I am getting a date of 01/13/1900
which is not what I want (calc!V2 is a real number)
What am I doing wrong ?
IF( A2 + monitor!B2 >= Today(),calc!V2,#N/A)
I want to take the value in WKS monitor cell B2 (say it is 3) and add it to whatever date is in ActiveSheet.A2
If that adds up being equal to or greater than today's date, I want to pull in a value
from another sheet. If not, display #N/A
instead I am getting a date of 01/13/1900
which is not what I want (calc!V2 is a real number)
What am I doing wrong ?