Thread
:
Entering IF formula
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Entering IF formula
Since dates are simply days then all you need is
=IF(a1="","",a1+180)
--
Don Guillett
SalesAid Software
"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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett