View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PamiS PamiS is offline
external usenet poster
 
Posts: 3
Default Entering IF formula

Thank you so much for your quick response Fred. It works just fine. I
appeciate your help.

"Fred Smith" wrote:

=if(a1="","",a1+180)

--
Regards,
Fred


"PamiS" wrote in message
...
I am very new to Excel and need to enter a formula for work asap.

What is the formula to enter: if cell A1 is blank then enter blank and if
not enter the date in A1 plus 180 days?

Help!