Hi All
I am in desperate need of a formula that rounds dates up for me. For example, if I have a date in D2 of 30/09/2011 I want it so that in C2 I get 31/12/2011. I need to be able to do this for a series of dates ranging from 01/01/2005 to 31/01/2013 , adding up to nearly a thousand records, as you can imagine, it would be incredibly inefficient for me to do this by hand.
Here's hoping someone out there can help.
Many Thanks,
Martin
Bookmarks