Hi there. Im looking for some help with a date formula that i need to return a specific date in the future if todays date falls within a date range. In fact there are 3 varients to the request.
*
Formula 1
************************************************************************************************ If today's date is between 1st and 20th of month return a date that is 1st of next month i.e.
***********************************************************************************************tToday's date - 17-Apr-18
Return date - 01-May-18
Formula 2********************************************************
If today's date is between 20th and end of month return a date that is 1st of next but one month i.e.******************************************************************************************************************
Today's date - 23-Apr-18
Returned date - 01-Jun-18
Formula 3*****************************************************************
The returned date needs to be the 1st of the next available month that is 28 days or more away from todays date i.e.:
***********************************************************************************************TToday's date - 23 April + 28 days = 21 May therefore next available month is June
Returned date - 01-Jun-18
Any help greatly appreciated :-)
Bookmarks