Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

edate

ResolvedVersion 2003

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

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 stephenATstl-training.co.uk and attach the workbook in question.

I will then have a look at the problem for you

Regards

Stephen

Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.