98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dates
Dates
Resolved · Urgent Priority · Version 2013
Thu 25 Feb 2016, 13:34Dee (guest) said...
Dates
Inputting date into spread sheet eg 01/01/2014 what formula do I use to calculate the next month 01/02/2014 without typing it in manually and how do I do this?
Thanks
Dee
Fri 26 Feb 2016, 09:11Trainer Andrew said...
RE: 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
Fri 4 Mar 2016: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Apply Autosum with keyboard shortcutIf you press Alt and = at the same time, it applies autosum. |
