Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statements with Dates
I'm trying to make a stock worksheet that gives me my stock data with a MS
Money web query. That works fine, what isn't working is, I have a worksheet called "Daily stocks" with dates starting in A3 and starts with todays date (todays date because I can't get my IF statement to work) and ends in 2009. I also have my stocks starting in B1 and ending in P1. Now to the problem On my daily stocks sheet I want the stocks to post automatically in on the date given and that works great. The stocks show up fine. The problem is, when the date changes to the next day, (say, April 27th) the stock quots in April 26 go blank or displays a 0. How can I make it so when the date changes the cells are left alone in the previous date cells? This is my formula: =IF(TODAY()=$A3,'Dons Stock'!$G$8,"") I want to copy that formula (or one that works) into all the cells down to 2009. But I want the previous date stocks to be left alone when the date changes to today, and the new stocks inserted for that day in that date. Any ideas would be grateful. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Statements with Dates | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
If statements and Dates | New Users to Excel | |||
Dates in IF statements | Excel Discussion (Misc queries) | |||
if statements & dates? | Excel Worksheet Functions |