Automating Month Ends For A Full Year?

HAWA

New Member
Joined
Jun 19, 2002
Messages
28
Hi, I have Excel 2000, and for some reason the formula doesn't work.

I get this result #NAME?

Also, C1 should end up being 03/31/04

Thank you,
Sam
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

north19701

Active Member
Joined
Jun 17, 2003
Messages
491
need to make sure the morefunc add-in is installed. go to tools - addins and make sure it's checked.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,295
Messages
5,571,390
Members
412,386
Latest member
Yasaman
Top