IF formula with dates

[Bob G]

How to...

Cell E10 is date format: April 15.
Cell F10 is the IF formula.

a. If E10 is blank, cell F10 should be blank.
b. If E10 has a date, cell F10 should add 45 days to it:
(E10+45)

Not having any success in cell F10!

Example: If(E10 <1,"",SUM(E10+45)) Result not correct.

Formula ideas, please and thanks.

 

[Jerry W. Lewis]

What are you getting that is not correct?

Jerry

 

[Anders S]

Bob,

In F10 enter:
=IF(E10="","",E10+45)
Format F10 as date.

HTH
Anders Silven

 

[Bob G]

Yes, it helped perfectly and thank you, again.

-----Original Message-----
Bob,

In F10 enter:
=IF(E10="","",E10+45)
Format F10 as date.

HTH
Anders Silven

"Bob G" <[email protected]> skrev i

meddelandet news:[email protected]...