Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
with if function
Some one great MVP solved my problem with this function
=(DATE(YEAR(E146),MONTH(E146)+3-MOD(MONTH(E146)-1,3),1)) but i just want to do more with this function. How it can be display blank when e146 does not have any date. when this function found date on particular cell then it calculate next 3 months dat. Thanks in advance Rao Ratan Singh |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
with if function
=IF(ISBLANK(E146,"",formula)
Jerry Rao Ratan Singh wrote: Some one great MVP solved my problem with this function =(DATE(YEAR(E146),MONTH(E146)+3-MOD(MONTH(E146)-1,3),1)) but i just want to do more with this function. How it can be display blank when e146 does not have any date. when this function found date on particular cell then it calculate next 3 months dat. Thanks in advance Rao Ratan Singh |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
with if function
this should take care of non numbers and non dates
=IF(ISTEXT(I14),"",IF(YEAR(I14)<2000,"",(DATE(YEAR (I14),MONTH(I14)+3-MOD(MONTH(I14)-1,3),1)))) -- Don Guillett SalesAid Software "Rao Ratan Singh" wrote in message ... Some one great MVP solved my problem with this function =(DATE(YEAR(E146),MONTH(E146)+3-MOD(MONTH(E146)-1,3),1)) but i just want to do more with this function. How it can be display blank when e146 does not have any date. when this function found date on particular cell then it calculate next 3 months dat. Thanks in advance Rao Ratan Singh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |