Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then date formulas
What I need is for todays date to show in a cell if a value equal to or
greater than one is placed in another cell. For instance, on an ordering form if a one is placed in a qty ordered cell todays date would show up in the last ordered cell. Hope that makes sense. I have been trying to figure this one out on my own and I give up. Thanks to all in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then date formulas
=IF(A11,TODAY(),"")
"IF A1 is greater than 1, THEN return today's date, ELSE do nothing." Note you can change "do nothing" to whatever you need it to do. -- Brevity is the soul of wit. "Brad" wrote: What I need is for todays date to show in a cell if a value equal to or greater than one is placed in another cell. For instance, on an ordering form if a one is placed in a qty ordered cell todays date would show up in the last ordered cell. Hope that makes sense. I have been trying to figure this one out on my own and I give up. Thanks to all in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then date formulas
You should then fix that value, otherwise if you open the file on
another day then it will show that day's date, rather than the date when the order was placed. Hope this helps. Pete Dave F wrote: =IF(A11,TODAY(),"") "IF A1 is greater than 1, THEN return today's date, ELSE do nothing." Note you can change "do nothing" to whatever you need it to do. -- Brevity is the soul of wit. "Brad" wrote: What I need is for todays date to show in a cell if a value equal to or greater than one is placed in another cell. For instance, on an ordering form if a one is placed in a qty ordered cell todays date would show up in the last ordered cell. Hope that makes sense. I have been trying to figure this one out on my own and I give up. Thanks to all in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then date formulas
How would I fix that so it stays on the date it was entered?
Thanks!!! Brad "Pete_UK" wrote: You should then fix that value, otherwise if you open the file on another day then it will show that day's date, rather than the date when the order was placed. Hope this helps. Pete Dave F wrote: =IF(A11,TODAY(),"") "IF A1 is greater than 1, THEN return today's date, ELSE do nothing." Note you can change "do nothing" to whatever you need it to do. -- Brevity is the soul of wit. "Brad" wrote: What I need is for todays date to show in a cell if a value equal to or greater than one is placed in another cell. For instance, on an ordering form if a one is placed in a qty ordered cell todays date would show up in the last ordered cell. Hope that makes sense. I have been trying to figure this one out on my own and I give up. Thanks to all in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then date formulas
Now that I think about it what I really want to have happen is for that value
to change when a new order is placed. So if today I order three and I save it and tomorrow I do not order then todays date is still in that field. If two days from now I order again then that days date would be in the field. If I use the formula that was suggested will that work or do I need to do something different? Thanks to all again. "Pete_UK" wrote: You should then fix that value, otherwise if you open the file on another day then it will show that day's date, rather than the date when the order was placed. Hope this helps. Pete Dave F wrote: =IF(A11,TODAY(),"") "IF A1 is greater than 1, THEN return today's date, ELSE do nothing." Note you can change "do nothing" to whatever you need it to do. -- Brevity is the soul of wit. "Brad" wrote: What I need is for todays date to show in a cell if a value equal to or greater than one is placed in another cell. For instance, on an ordering form if a one is placed in a qty ordered cell todays date would show up in the last ordered cell. Hope that makes sense. I have been trying to figure this one out on my own and I give up. Thanks to all in advance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then date formulas
Ok. Thanks! To add to what information I have given you..... If I put an
order in today and I put a qty in that field then todays date will show in the other field. I need that date to stay until I order that item again. So if I order again tomorrow tomorrows date will show. If I do not order for three days then todays date will stay on that line until then...... Hope that makes sense. Will what you gave me on it's own work ok? Thanks again! brad "Dave F" wrote: =IF(A11,TODAY(),"") "IF A1 is greater than 1, THEN return today's date, ELSE do nothing." Note you can change "do nothing" to whatever you need it to do. -- Brevity is the soul of wit. "Brad" wrote: What I need is for todays date to show in a cell if a value equal to or greater than one is placed in another cell. For instance, on an ordering form if a one is placed in a qty ordered cell todays date would show up in the last ordered cell. Hope that makes sense. I have been trying to figure this one out on my own and I give up. Thanks to all in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Date formulas needed | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |