Dates

Hi Dee

you can use the EODATE() function to work out the end of the current month then add 1 to give you the first of the next month. It would look like this


A1 contains the current date
A2 is formatted as a date
The formula is in A2

=EODATE(A1,0)+1

I hope this helps - let me know if you have any questions.

Kind regards,
Andrew