Quote:
Originally Posted by Luke M
With your first date in B1:
=IF(DAY(B1)=1,DATE(YEAR(B1),MONTH(B1),15),
DATE(YEAR(B1),MONTH(B1)+1,1))
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
|
Elegant, simple, genius!... Just what I was looking for!
Great job Luke!
Though, I'm new to this site, and not sure where to "click yes"...