Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default IF TODAY equals date in cell A10, or if TODAY is beyond that date

Here's another one for those much smarter than me. Cell A10 will have a
static date. If we have reached that date or gone beyond it then I want A20
to equal 10. Any ideas? Thanks for your help.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,355
Default IF TODAY equals date in cell A10, or if TODAY is beyond that date

A20: If(A10<=today(),10,"")

HTH,
Barb Reinhardt

"SoupNazi" wrote:

Here's another one for those much smarter than me. Cell A10 will have a
static date. If we have reached that date or gone beyond it then I want A20
to equal 10. Any ideas? Thanks for your help.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 698
Default IF TODAY equals date in cell A10, or if TODAY is beyond that date

Try something like this:

A20: =IF(TODAY()=INT(A10),10,"not due")

Note: I used the INT function in case A10 includes a time value
eg: 4/22/2007 5:00:00 AM

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"SoupNazi" wrote:

Here's another one for those much smarter than me. Cell A10 will have a
static date. If we have reached that date or gone beyond it then I want A20
to equal 10. Any ideas? Thanks for your help.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default IF TODAY equals date in cell A10, or if TODAY is beyond that date

Enter in A20:

=10*(A10<=TODAY())

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"SoupNazi" wrote in message
...
Here's another one for those much smarter than me. Cell A10 will have a
static date. If we have reached that date or gone beyond it then I want

A20
to equal 10. Any ideas? Thanks for your help.


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default IF TODAY equals date in cell A10, or if TODAY is beyond that d

Looks like these will work fine. Thanks Barb & Ron

"Barb Reinhardt" wrote:

A20: If(A10<=today(),10,"")

HTH,
Barb Reinhardt

"SoupNazi" wrote:

Here's another one for those much smarter than me. Cell A10 will have a
static date. If we have reached that date or gone beyond it then I want A20
to equal 10. Any ideas? Thanks for your help.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MAX figure within a date range as a function of today()'s date irvine79 Excel Worksheet Functions 6 February 20th 07 04:28 PM
Computing days between TODAY() and older date in a cell Big UT Fan Excel Discussion (Misc queries) 3 November 14th 06 09:14 PM
how do I program a cell to automatically fill in today;s date? allanlevy7342 Excel Worksheet Functions 1 September 12th 06 03:24 PM
SUMIF within date range as a function of today()'s date irvine79 Excel Worksheet Functions 8 August 6th 06 05:55 PM
go to cell with date equaling TODAY() James D Excel Discussion (Misc queries) 1 January 14th 06 12:52 AM


All times are GMT +1. The time now is 12:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"