First date of next month?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I have a cell where I put a date A1. I need a formula where it will
produce the first date of the next month.


Thanks for any help.
 
Try this:
=EOMONTH(A1,0)+1

Note: If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in

Does that help?
 
Back
Top