dear excel experts
good evening to all
CALCULATE HOURS START WITH OPEN DATE FROM (LARGEST DATE) BETWEEN(SEASON 1,2,3)
OR SEASON-1
OR SEASON-2
OR SEASON-3
WITH END DATE.
END DATE SHOULD BE GREATER THAN CALCULATION DATE IF ITS NOT GREATER THAN CALCULATE DATE RESULT "END DATE LESSER THAN CALCULATION DATE"
pls find the attachment
HI Breadwinner,
Use below formula:-
Formula:
Please Login or Register to view this content.
FORUM (1).xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Nice Pandey Thanks alot it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks