Forum Discussion
Solved
Excel Formula
Hi
I need a formula in excel to return the value of the current month if it is coming in between two mentioned dates
- Thanks Sergei - Its working Apprecited for your support
17 Replies
- Dear asifrizvi, could you please specify your needs with an example? Regards Maurizio
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
