Using Edate, if Date range is blank show blank

[Garry1965]

Hi All

I'm very new to this so I will apologise now if this seems longwinded.
I have been asked to create an "Equipment Register" at work.
The equipment is meant to be inspected every 3 months. Not all equipment is inspected on the same date so the inspection dates vary considerably.

I want to include a 'Next Inspection Due' date in one of the columns.

Assume I have an item in row 1. the first few columns show the items details. Then I have multiple columns with inspection dates
In cell H1 I want the next inspection due date. (3 months after the last one)
In cells Q1:AZ1 I have the actual date of the inspections.

In H1 I have the formula =EDATE(MAX(H1:AZ1),3) This works.

However, I want to build this so that additional items can be entered later by the storeman.

The problem is when I copy the formula into rows that have no data yet. Because all the date columns are blank, cell H1 defaults to show 31/3/00..
How do I get it to show blank when the inspection columns are blank yet still function properly after a new date is entered.

 

[FormR]

Hi, you could give this a try:

=IF(COUNT(H1:AZ1),EDATE(MAX(H1:AZ1),3),"")

 

[Garry1965]

Excellent,, I hadn't tried using COUNT,, It works perfectly!

Thank you

G