Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isblank
I am trying to enter a formula to calculate a date 30 days later in cell b1
only if cell a1 has a date. If cell a1 does not have a date then leave b1 blank. I am getting a return date of 30-Jan-00 when cell a1 is blank. I don't understand why 30-Jan-00 comes up. This is the formula that I am using: =IF(ISBLANK(A1),"",IF(COUNT(A1+30),A1+30,"")) Thank you in advance for your help. Eileen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isblank
Your function seems to work for me (the logic part). Right-click on the cell
that reads '30-Jan-00' then select an appropriate format...perhaps General, Date, or Custom. Try different scenarios until you get what you want. Regards, Ryan--- -- RyGuy "Eileen" wrote: I am trying to enter a formula to calculate a date 30 days later in cell b1 only if cell a1 has a date. If cell a1 does not have a date then leave b1 blank. I am getting a return date of 30-Jan-00 when cell a1 is blank. I don't understand why 30-Jan-00 comes up. This is the formula that I am using: =IF(ISBLANK(A1),"",IF(COUNT(A1+30),A1+30,"")) Thank you in advance for your help. Eileen |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isblank
=IF(ISBLANK(a1),"",DATE(YEAR(a1),MONTH(a1), DAY(a1)+30))
"Eileen" wrote: I am trying to enter a formula to calculate a date 30 days later in cell b1 only if cell a1 has a date. If cell a1 does not have a date then leave b1 blank. I am getting a return date of 30-Jan-00 when cell a1 is blank. I don't understand why 30-Jan-00 comes up. This is the formula that I am using: =IF(ISBLANK(A1),"",IF(COUNT(A1+30),A1+30,"")) Thank you in advance for your help. Eileen |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isblank
=IF(A1="","",A1+30)
-- David Biddulph "Eileen" wrote in message ... I am trying to enter a formula to calculate a date 30 days later in cell b1 only if cell a1 has a date. If cell a1 does not have a date then leave b1 blank. I am getting a return date of 30-Jan-00 when cell a1 is blank. I don't understand why 30-Jan-00 comes up. This is the formula that I am using: =IF(ISBLANK(A1),"",IF(COUNT(A1+30),A1+30,"")) Thank you in advance for your help. Eileen |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isblank
The only way that your formula could return 30-Jan-00 is if A1 contains a
number =0, <1 or the logical value FALSE. If A1 is empty or contains a formula blank ("") the result will be "". Maybe A1 contains 0 but you have 0 display turned off: ToolsOptionsView tabZero display. Try this (assuming that only true Excel dates are to be entered in A1): =IF(AND(COUNT(A1),A10),A1+30,"") -- Biff Microsoft Excel MVP "Eileen" wrote in message ... I am trying to enter a formula to calculate a date 30 days later in cell b1 only if cell a1 has a date. If cell a1 does not have a date then leave b1 blank. I am getting a return date of 30-Jan-00 when cell a1 is blank. I don't understand why 30-Jan-00 comes up. This is the formula that I am using: =IF(ISBLANK(A1),"",IF(COUNT(A1+30),A1+30,"")) Thank you in advance for your help. Eileen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK() | Excel Worksheet Functions | |||
isBlank() | Excel Worksheet Functions | |||
ISBLANK | Excel Worksheet Functions | |||
IF(ISBLANK) | Excel Worksheet Functions | |||
If(ISBLANK) | Excel Worksheet Functions |