|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Mar 30th, 2004, 05:48 PM
|
#1 |
|
Join Date: Mar 2004
Location: NC
Posts: 3
|
Excel dates
I have a Due Date Spreadsheet where I have used Conditional formating to show the dates that are overdue in red, within 30 days in yellow and everything else in green. However, there some that have no dates and the formula always posts a date. I want to eliminate that date until a date has been put in a specific box. I.E
A1= 1 Mar 02 B1= A1+365 (1 Mar 03) A2= Blank B2= A2+365 (30 Dec 00) the parenthesis denotes the answer returned from the formula. I wish to have the cell blank rather than showing the date of (30 Dec 00) if the prior cell has no information either. Can anyone help me out on this?
__________________
Without Weather the Pilots Would be lost in the clouds. |
|
|
|
Mar 30th, 2004, 05:50 PM
|
#2 | |
Join Date: Feb 2002
Posts: 7,599
|
Re: Excel dates
Quote:
=IF(A2,A2+365,"") |
|
|
|
|
|
Mar 30th, 2004, 05:50 PM
|
#3 |
|
Join Date: Mar 2002
Posts: 292
|
Re: Excel dates
try
B2= if(isblank(A2),"",A2+365) HTH |
|
|
|
|
Mar 30th, 2004, 05:54 PM
|
#4 |
|
Join Date: Mar 2004
Location: NC
Posts: 3
|
Re: Excel dates
Thanks for the help.....Sorry it was a simple no duh question.
__________________
Without Weather the Pilots Would be lost in the clouds. |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
