• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Please advise function/formula to display date

S

Sachin536

New Member
Dear Sir,

as per the attached excel sheet, please tell me any formula to display the actual job start date in the G column.(e.g g7)

regards,

Sachin
 

Attachments

  • MACHINE WISE PRODUCTION HOURS DATE.xlsx
    10.7 KB · Views: 4
Dear Sir,

thank you very much for your reply,

enclosed is the revised excel sheet, can you please help me with a formula to display the actual job start date in the G column.(e.g g7) and the job end date in the K column.(e.g k7)




regards,

Sachin
 

Attachments

  • MACHINE WISE PRODUCTION HOURS DATE.xlsx
    10.9 KB · Views: 4
Sachin536
Based Your sample eg write to cell J7 =SUMIFS($D7:$I7,$D7:$I7,">0",$D$6:$I$6,J$5) and copy as needs.
Be careful with those 'extra' spaces in the end of Your data.
 
Dear Sir,

thank you very much for your reply,

again I enclosed the revised excel sheet, can you please last time help me with a formula to display the actual job start date in the M column.(e.g m4) and the job end date in the N column.(e.g n4)

it was difficult to understand me, hence i request you to pls help with the formula.

please note, as per the attached sheet, I need to show the final job start date & end date in separate columns i.e. in m4 comes the final job start date and in n4 comes the final job end date.

i am waiting for your response.

regards,


sachin
 

Attachments

  • MACHINE WISE PRODUCTION HOURS DATE -1.xlsx
    9.6 KB · Views: 2
Last edited:
Sachin536
Above ... something ... seems to related with Your previous thread - about VlookUp, which You seems to skip.
Is Your next ... question ... from case which has one more pair of job end times?
... and do You'll continue after that to add one more pair again?
Your ... please do the needful ... means,
Please ... Could You try to figure
- What are You looking for?
- What do You really need?
This seems to be endless like 1+2=? >> 1+2+3=? >> 1+2+3+4=? and so on.
 
thanks for your continous support,

please ignore the above recent query,

actually, just i shared a sample data, but now it's resolved with your help.

as per the attached excel, my main purpose is to just show the job start date in the final job start date columns with ignoring the #N/A.

and I used it in this Aggregate function.

Thanks
 
You must log in or register to reply here.
Back
Top