Hi, is there a formula that will generate and end of month date?
For example: today's date is the 23/11/2011 if this was entered into cell A1 I'd like a formula to return in B1 the last day of that particular month in date format. This would be for this example 30/11/2011.
Thanks in anticipation.
BMC
Bookmarks