If Then Question Regarding Dates
 

If anyone can help with this scenario, it would be much appreciated.

I want to compare a formula driven date with today's date in a
spreadsheet. For example, if the date in one cell has already passed,
then I want to have a value in another cell. If the date is in the
future, then the value in the aforementioned cell would be null.

Originally, I put =if(a1<()today, $100, 0), but it is obviously not
correct.

Can anyone drop a clue or two?

Thanx.

PHEB


--
PHEB
------------------------------------------------------------------------
PHEB's Profile: http://www.officehelp.in/member.php?userid=4551
View this thread: http://www.officehelp.in/showthread.php?t=1217328

Posted from - http://www.officehelp.in

If Then Question Regarding Dates
 

=IF(A1TODAY(),100,0) Will only work if A1 is formatted as a date, I believe.

Dave
--
Brevity is the soul of wit.


"PHEB" wrote:


If anyone can help with this scenario, it would be much appreciated.

I want to compare a formula driven date with today's date in a
spreadsheet. For example, if the date in one cell has already passed,
then I want to have a value in another cell. If the date is in the
future, then the value in the aforementioned cell would be null.

Originally, I put =if(a1<()today, $100, 0), but it is obviously not
correct.

Can anyone drop a clue or two?

Thanx.

PHEB


--
PHEB
------------------------------------------------------------------------
PHEB's Profile: http://www.officehelp.in/member.php?userid=4551
View this thread: http://www.officehelp.in/showthread.php?t=1217328

Posted from - http://www.officehelp.in

If Then Question Regarding Dates
 

Try this:

=if(a1<today(), $100, 0)

Hope this helps.

Pete

PHEB wrote:
If anyone can help with this scenario, it would be much appreciated.

I want to compare a formula driven date with today's date in a
spreadsheet. For example, if the date in one cell has already passed,
then I want to have a value in another cell. If the date is in the
future, then the value in the aforementioned cell would be null.

Originally, I put =if(a1<()today, $100, 0), but it is obviously not
correct.

Can anyone drop a clue or two?

Thanx.

PHEB


--
PHEB
------------------------------------------------------------------------
PHEB's Profile: http://www.officehelp.in/member.php?userid=4551
View this thread: http://www.officehelp.in/showthread.php?t=1217328

Posted from - http://www.officehelp.in

If Then Question Regarding Dates
 

Dave,

that would put A1 in the future to return 100.

Pete

Dave F wrote:
=IF(A1TODAY(),100,0) Will only work if A1 is formatted as a date, I believe.

Dave
--
Brevity is the soul of wit.


"PHEB" wrote:


If anyone can help with this scenario, it would be much appreciated.

I want to compare a formula driven date with today's date in a
spreadsheet. For example, if the date in one cell has already passed,
then I want to have a value in another cell. If the date is in the
future, then the value in the aforementioned cell would be null.

Originally, I put =if(a1<()today, $100, 0), but it is obviously not
correct.

Can anyone drop a clue or two?

Thanx.

PHEB


--
PHEB
------------------------------------------------------------------------
PHEB's Profile: http://www.officehelp.in/member.php?userid=4551
View this thread: http://www.officehelp.in/showthread.php?t=1217328

Posted from - http://www.officehelp.in

If Then Question Regarding Dates
 

You're close.

The parentheses follow the function, not precede it. Also, take out the '$',
leaving just the number,

=if(a1<today(),100,0)

If you want $ to appear, format the cell as currency.

--
Regards,
Fred


"PHEB" wrote in message
...

If anyone can help with this scenario, it would be much appreciated.

I want to compare a formula driven date with today's date in a
spreadsheet. For example, if the date in one cell has already passed,
then I want to have a value in another cell. If the date is in the
future, then the value in the aforementioned cell would be null.

Originally, I put =if(a1<()today, $100, 0), but it is obviously not
correct.

Can anyone drop a clue or two?

Thanx.

PHEB


--
PHEB
------------------------------------------------------------------------
PHEB's Profile: http://www.officehelp.in/member.php?userid=4551
View this thread: http://www.officehelp.in/showthread.php?t=1217328

Posted from - http://www.officehelp.in