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

[r_2]

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.

 

[prasaddn]

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

 

[r_2]

thnx prasad...