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?
 
Thanks for the feedback, Randy
I'm glad "=EOMONTH(A1,0)+1" worked for you.
 
You must log in or register to reply here.

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

Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Excel Message box with days of month & date. 1
Excel Vba to change displayed year automatically. 14
Excel Date of first friday every month 3
Benefits Eligibility Dates 3
First day of Next Month 5
Excel Help with dates 2
Date search query 0

Back
Top