Lead time date

[stormania]

Dear excel master

Kindly help how to count lead time as attach file, especially count if end transaction in Sept 28, how to count lead time in full month.



Thank you in advance

 

[bosco_yip]

Try,

In H4, formula copied down:

=IF(F4="","",IF(F4<0.01,0,IF(LEFT(A5)="E",EOMONTH(A4,0)-A4,A4-A3)))

 

[stormania]

Problem solved, thank you