Completion & Pending tasks based on dates.

[Muthukrishnan V]

MS Excel 2007.

Col R contains dates varying from 1st April 2018 to 31st December 2018 in
DD/MM/YYYY format. (Dates showing task to be completed).

Col S formatted in date format DD/MM/YYYY. The date is entered as and when the
task is completed. For example R11 shows date 17-04-2018. Task completed
and now S11 is entered 17-04-2008.

Similarly task dated in R10 16-04-2018 is not completed therefore S10 is blank,
meaning task pending.

Col T represents Status. With the above examples, I want T11 to return Yes; and T10 to return pending, only in respect of task dates for the current month that is where
Col R >= 01-04-2018 and <= 30-04-2018. By way of clarification, the status of
completion and pending, is needed for the current month only.

Kindly advise me formula for Col T.

 

[SteveO59L]

I put =today() in a1, then in t1

=IF(MONTH(R1)<>$A$1,"",IF(S1<>"","complete","pending"))

and fill down

 

[Muthukrishnan V]

Thank you for answering my query Sir, but this is not working for me. A1 is =today() R1 is 19-04-2018 S1 is 19-04-2018 and T1 is blank.
The correct answer in the instant example is: T1 completed. Kindly help, Sir.

 

[SteveO59L]

correction

=IF(MONTH(R1)<>MONTH($A$1),"",IF(S1<>"","complete","pending"))

 

[Muthukrishnan V]

Thank you Steve059L Sir,