LinkBack URL
About LinkBacks
I have a column of data that requires the cell to be blank if the value is 00/01/1900.
The data is linked to another cell.
IE: cell E3 is linked to cell $D$3
The cell is formatted for dates in the format shown.
Any Help please.
I have a column of data that requires the cell to be blank if the value is 00/01/1900.
The data is linked to another cell.
IE: cell E3 is linked to cell $D$3
The cell is formatted for dates in the format shown.
Any Help please.
Last edited by Butehawk; 05-12-2010 at 05:18 PM.
=If(E3 = "00/01/1900", "", E3)
If that does not work you need to check the cell value that is coming back as 00/01/1900 and put that in the formula.
so,
=If(E3 = 0, "", E3)
DP978
Many thanks that worked with the zero option
Thanks
Your very welcome. Glad to have helped.
If the blank requirement is based upon aesthetics you can also use a basic Number Format to do the same without the duplicate logic, ie:
=E3
custom format of: dd/mm/yyyy;;
this also has the added advantage of maintaining a consistent data type in the underlying values (numerics) - ie the 0 persists it's simply not visible (other than via formula bar etc...)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I have the exact same problem, but unfortunately these answers have not solved my problem. The date that appears on my spreadsheet is 31/12/00
I have variants of this formula that creates the dates in G column:
=DATE(YEAR(F4)+1,MONTH(F4),DAY(F4))
I tried adding the recommendations as an extra part, for example:
=DATE(YEAR(F4)+1,MONTH(F4),DAY(F4))&If(F4 = 0, "", F4)
It always brings back the answer of 366, and does not make the cell blank...
Any help?
Antligen,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Apologies! I'm new to using forums, I will make a new thread and go from there
Hi All
Could you help me resolve a issue I have. I have a start date in c2 and a expired date in e2. When I add =c2+21 is shows me the correct date in e2 but when I take the date out of c2 I get 21/01/1900 in e2. Is their anyway around this show it done show this or is their another way of doing the formula.
Thanks
Rick
Ricky, perhaps you missed thread # 7?
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Apologies, I posted this before seeing the thread.
I have posted my own thread in which I have the answer to now.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks