Forum Discussion
Excel Formula
- Thanks Sergei - Its working Apprecited for your support
mauriziogioplease find the exact requirement
| WorkEffortStartDate | WorkEffortEndDate | Result |
| 17-Feb-20 | 31-May-20 | Is current date ( e.g 21 Apr 20) is in between the WorkEffort Start Date & WorkEffortEndDate if Yes the return the current month & year |
| 28-Jan-20 | 31-Dec-20 | |
| 24-Feb-20 | 31-Dec-21 | |
| 08-Oct-18 | 31-Dec-19 | |
| 11-Feb-20 | 31-Dec-20 | |
| 21-Jan-19 | 30-Apr-19 | |
| 24-May-19 | 31-Dec-20 | |
| 27-Mar-19 | 19-Jul-19 |
Hi mauriziogio
Can you please help me get the desired output
Based of the below mentioned formula , it is comparing today date & it is coming in between my start & end date then reflecting month which is absolutely working fine as per my last request , but if from a below table - need result displayed as RESULT =CURRENT MONTH & RESULT = Y/N in different columns
Start Date End Date Is any date of the current month part of ( between Start Date to End Date) ? RESULT = CURRENT MONTH Example RESULT ( Yes/No ) 9/3/2019 3/31/2020 No 3/9/2018 3/31/2020 No 10/18/2019 3/31/2020 No 9/1/2019 3/31/2020 No 10/31/2019 3/31/2020 No 11/20/2019 3/31/2020 No 3/2/2020 4/1/2020 Apr-20 Yes 9/10/2018 4/5/2020 Apr-20 Yes 11/15/2019 4/10/2020 Apr-20 Yes 8/15/2018 4/15/2020 Apr-20 Yes 2/19/2020 4/27/2020 Apr-20 Yes 3/20/2020 4/38/2020 Apr-20 Yes 6/19/2019 4/29/2020 Apr-20 Yes 3/10/2018 4/30/2020 Apr-20 Yes =IF( (TODAY()>=A2)*(TOADY()<=B2), TODAY(),"")
and apply mmm yy custom format
- Thanks -It's working Appreciated
Perhaps
=IF( (TODAY()>=A2)*(TOADY()<=B2), TODAY(),"")and apply mmm yy custom format
If you mean that's for each record, not for entire table at once.
Hi Sergei SergeiBaklan
Based of the below mentioned formula , it is comparing today date & it is coming in between my start & end date then reflecting month which is absolutely working fine as per my last request , but if from a below table - need result displayed as RESULT =CURRENT MONTH & RESULT = Y/N in different columns
Start Date End Date Is any date of the current month part of ( between Start Date to End Date) ? RESULT = CURRENT MONTH Example RESULT ( Yes/No ) 9/3/2019 3/31/2020 No 3/9/2018 3/31/2020 No 10/18/2019 3/31/2020 No 9/1/2019 3/31/2020 No 10/31/2019 3/31/2020 No 11/20/2019 3/31/2020 No 3/2/2020 4/1/2020 Apr-20 Yes 9/10/2018 4/5/2020 Apr-20 Yes 11/15/2019 4/10/2020 Apr-20 Yes 8/15/2018 4/15/2020 Apr-20 Yes 2/19/2020 4/27/2020 Apr-20 Yes 3/20/2020 4/38/2020 Apr-20 Yes 6/19/2019 4/29/2020 Apr-20 Yes 3/10/2018 4/30/2020 Apr-20 Yes =IF( (TODAY()>=A2)*(TOADY()<=B2), TODAY(),"")
and apply mmm yy custom format
If you mean that's for each record, not for entire table at once.
asifrizvi please find mofied example
- Thanks a ton , Sergei - Instead of "mmm" need to get the current date -(month+year )
You may apply any format you wish, dd mmm yy, whatever
