Format Start Date and End Date cells using custom format (d.mm.)
Start Date (A1
Number of Days (B1)
End Date (C1)
C1 contains =A1+B1
Maggie
On May 6, 6:13 am, dare2gold wrote:
> Dear Members,.,
>
> i want to know how to get a later date just by inserting present date
> into one column and
Hi Chandrabhan,
Try this:
=IF(B3="Lead",B3,IF(C3="Lead",C3,IF(D3="Lead",D3,IF(LEN(D3)<>0,D3,IF(LEN(C3)<>0,C3,IF(LEN(B3)<>0,B3,"Not
attempted"))
Maggie
On May 4, 7:07 am, Born to Win wrote:
> Hi friends,
>
> I need ur favour Please check it.
>
> Thanks,
> Chandrabhan Singh
> 9911255330
>
> -
Hi,
This is not complete, but you could use a nested IF Statement.
Something like this in cell P6
=IF(LEN(N6)>0,N6,IF(LEN(M6)>0,M6,IF(LEN(L6)>0,L6,K6)))
On Jan 14, 11:40 pm, ankur wrote:
> hi Gurmeet
> can i have sample file,then it will be easy
> Have A Nice Time & Enjoy Life
>
> Regard
