Value is BLANK
 

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!
==============================================



"Kenny Dee" wrote in message
...
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.

=IF(A1="","",A1+5)......format the cell as date........

Vaya cno Dios,
Chuck, CABGx3




"Kenny Dee" wrote in message
...
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.