In G2 copied down.
Formula:
=IF(C2=C1,IF(D2=E1+1,DATEDIF(D1,E2,"m"),""),"")
In G2 copied down.
Formula:
=IF(C2=C1,IF(D2=E1+1,DATEDIF(D1,E2,"m"),""),"")
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks