First date of next month?

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.
 
R

Ron Coderre

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Repeating a row other than the 1st row as the header row in a table from next page 1
VBA - exporting serial letters to single documents 0
Crating User Form to Add Names 1
How to change date format to 7 working days a week in ms project 2010? 0
Autofill Date in Word 15.33 for Mac 0
Autopopulating a date 1
Notes not showing up in Powerpoint Presenter Mode 0

Top