Sum if

Hi, Good morning

Another help, if the status is joined only, please calculate the difference between Date of joining and request date, other wise Bank, please help me with formulae

Please refer the below table or attached file

Status Req Date offer rel date Date of Joining Ageing
Joined 15-Jun-11 3-Jul-11 3-Oct-11 109

regards
Sagar

Good morning,


=IF(D2="Joined",G2-E2-1,"Bank")

Regards

Try this

Please Login or Register  to view this content.

It will be 110 as from 15 jun to 30 jun there are 16 days not 15 days

thank you very much