Value is BLANK

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.
 
R

RagDyer

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dateadd function question.. 0
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Access Property sheet data missing also syntax 0
conditional formatting 1
once every year, ideas please ? 1
CALCULATING DATES 3
Insert rows in Excel Ledger problem 8
Excel 2 into 1 6

Top