• 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.

hi, need a help on setting if criteria on specific date

r_2

Member
hi, need a help on setting if criteria on specific date.
While for calculation of TAT days before a specific date I need to set a another column against which their desired deadlines are set so that i can calculate their networkdays by subtracting it

EX- if a item was delivered in a location before 1st April , there TAT time is 4 days & after 1st April its 6 days.

i have tried to set criteria in column F.

kindly rectify it or share a another criteria.
 

Attachments

  • if_date _criteria.xlsx
    9.1 KB · Views: 0
Hi,

You could do this in many ways. here I have mentioned three methods:
1. enter the cut off date (04/01/2015) in lets say F1 cell and then use the below formula and drag down to your required rows:
=IF(C2<$F$1,4,6)

2. using datevalue():
=IF(C2<DATEVALUE("04/01/2015"),4,6)

3. using date's serial number, 42095 is equivalent to 04/01/2015:
=IF(C2<42095,4,6)

Regards,
Prasad DN
 
Back
Top