Excel dates

Mordax · Mar 30th, 2004, 05:48 PM

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?

Mar 30th, 2004, 05:48 PM	#1
Mordax 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode