Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula
Please Help. I have two cells, A1, B1. In B1 I want the current date if A1
is populated. If A1 is not populated I would like the message "< Input" in B2. Here is my formula in B1: =IF(A1="","< Input",TODAY()) It should be so simple, but I can't seem to make it work. Can anyone tell me what is wrong?? Thanx for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula
I don't see anything wrong with the formula.
Make sure you set your calculation to Automatic. "Grumpy" wrote: Please Help. I have two cells, A1, B1. In B1 I want the current date if A1 is populated. If A1 is not populated I would like the message "< Input" in B2. Here is my formula in B1: =IF(A1="","< Input",TODAY()) It should be so simple, but I can't seem to make it work. Can anyone tell me what is wrong?? Thanx for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula
in cell b1:
=IF(ISBLANK(A1),"< Input",TODAY()) format b1 to suit Jim "Grumpy" wrote in message ... Please Help. I have two cells, A1, B1. In B1 I want the current date if A1 is populated. If A1 is not populated I would like the message "< Input" in B2. Here is my formula in B1: =IF(A1="","< Input",TODAY()) It should be so simple, but I can't seem to make it work. Can anyone tell me what is wrong?? Thanx for your help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula
Your formulas works for me. Be aware though, ="" is NOT the same as A1 being
empty as a formula (in which case the cell is not empty) can return "" (empty text). You MIGHT need; =IF(ISBLANK(A1),"< Input",TODAY()) -- Regards Dave Hawley www.ozgrid.com "Grumpy" wrote in message ... Please Help. I have two cells, A1, B1. In B1 I want the current date if A1 is populated. If A1 is not populated I would like the message "< Input" in B2. Here is my formula in B1: =IF(A1="","< Input",TODAY()) It should be so simple, but I can't seem to make it work. Can anyone tell me what is wrong?? Thanx for your help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula
Maybe you have a space character in A1.
You could select A1 and hit the delete key on the keyboard to clear the contents of that cell. Or you could change your formula: =if(trim(a1)="","< Input",Today()) If this doesn't help, make sure that you have calculation turned to automatic. In xl2003 menus, it's under: Tools|Options|Calculation tab === Just an aside, if A1 has something in it, your formula will return the current date -- each day it'll change. If you want that date to be static, you'll need a different approach. Take a look at JE McGimpsey's site: http://www.mcgimpsey.com/excel/timestamp.html for a macro approach. Grumpy wrote: Please Help. I have two cells, A1, B1. In B1 I want the current date if A1 is populated. If A1 is not populated I would like the message "< Input" in B2. Here is my formula in B1: =IF(A1="","< Input",TODAY()) It should be so simple, but I can't seem to make it work. Can anyone tell me what is wrong?? Thanx for your help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) |