Value is BLANK

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a form i'm working on i've asked this question before and i'm unable to
locate the replies, but in one cell I have a date to be enter and in the
other cell it takes that date and add 5 days to the date to give me a due
date. But if no date is enter then I want to to remain blank insted giving me
a date.
 
Say that the date is to be entered into A1, then enter this formula into the
"other" cell:

=IF(A1,A1+5,"")
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top