Excel formula

I have 4 columns one with actual ticket received date, 1 with current date and 1 with physical doc received date and last one the mode of ticket.

 

If the mode reads “Physical” the output should be current date minus the physical received date

If the mode reads “Scan” the output should be current date minus the actual ticket received date.

 

How to apply the formula so that I do not have to manually input every day or twice a day to generate a report

 

Thanks in advance

 

 

 

By: Srikanth

Leave a Reply

Your email address will not be published. Required fields are marked *