Mashtonsmith
Board Regular
- Joined
- Oct 1, 2004
- Messages
- 164
Hello,
I need a basic formula that will always give me the next closest 1st May.
Date 1 Date 2
17/10/2014 01/05/2015
01/02/2015 01/05/2015
01/07/2012 01/05/2013
Date 1 = hard dates
Date 2 = shows the result required - but I need the formula to do it please!
Thanks
I need a basic formula that will always give me the next closest 1st May.
Date 1 Date 2
17/10/2014 01/05/2015
01/02/2015 01/05/2015
01/07/2012 01/05/2013
Date 1 = hard dates
Date 2 = shows the result required - but I need the formula to do it please!
Thanks