If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using the returned value of a function
I am trying to have a value automatically enetered into a range of cells if
the date at the top of the column matches today's date. I have tried using the "Today()" and "IF" functions with no luck. |
#2
|
|||
|
|||
Using the returned value of a function
adombrowski Wrote: I am trying to have a value automatically enetered into a range of cells if the date at the top of the column matches today's date. I have tried using the "Today()" and "IF" functions with no luck. Hi adombrowski Assuming the the date to be in cell A1, try this =IF(A1=TODAY(),1,0), this will return the value 1 if the date in A1 is the same as today and zero if they are not the same. You can change these values to suit your needs -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=495097 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why the flag: "An internal support function returned an error" ? | Busyman | General Discussions | 0 | November 23rd, 2005 11:45 PM |
Excel option to store trendline's coefficients in cells for use | Miguel Saldana | Charts and Charting | 9 | June 20th, 2005 08:45 PM |
PLEASE HELP with the SPELLNUMBER function | vag | Worksheet Functions | 0 | June 16th, 2005 01:33 PM |
Hi - RPC over HTTP problem: | MarkInIreland | Installation & Setup | 3 | March 13th, 2005 02:29 PM |
What if the back-end "moves"? | John S. Ford, MD | General Discussion | 13 | November 15th, 2004 09:33 PM |