View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Seemingly blank cell, if you have a formula returning a blank it is not
empty so you might want to use

=IF($Q2<"",F2+90,"")

if you by any chance are using spaces

=IF(TRIM($Q2)<"",F2+90,"")

--
Regards,

Peo Sjoblom

(No private emails please)


" Pivot Table/Query" wrote
in message ...
I have a new spreadsheet that I need to calculate a due date (column X)
based
on the initial appointment date (column Q).(the next appointment would be
90
days after the initial appointment) I want it to ignore blank cells. I
have
used the following formula which calculates the info fine, but it adds 90
days to blank cells also and gives me 3/30/1900. Please help
=IF(NOT(ISBLANK($Q2)),F2+90,"")