Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » EDATE

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

EDATE

Resolved · High Priority · Version 2003

Reply Fri 22 Aug 2008, 12:13Delegate Veronika said...

Veronika has attended:
Excel Advanced course
Powerpoint Intermediate Advanced course

EDATE

Hello,

in my first cell (A1) I want to show today's date, hence =TODAY()
in the cell below i want to show the next month' date, hence =EDATE(A1,1)

However I am getting a #NAME? error message.

Who can help?

Thanks,

Veronika

For upcoming training course dates see: Pricing & availability

Reply Fri 29 Aug 2008, 10:21Trainer Stephen said...

RE: EDATE

Hi Veronika

Thank you for your question

I have replicated the steps you describe and it worked fine for me. There could be a problem with the formatting of your wokbook

I suggest you email me at stephenATmicrosofttraining.net and attach the workbook in question.

I will then have a look at the problem for you

Regards

Stephen

Excel articles

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Differences In Excel 2003, 2007 And 2010
· Learn The Secrets Of COUNT Functions In Excel
· Excel in the Home Office
· A Quick Guide To Conditional Formatting In Excel 2007/2010

Please browse our web site to find out more about
microsoft.excel.courses.in.london and other Microsoft training courses.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips