Automating Month Ends For A Full Year?

H

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

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
N

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.
 
You must log in or register to reply here.

Similar threads

B
  • Question
"Flag" the months between two dates
Replies
1
Views
80
BiggusDoggus
B
F
  • Solved
Fill blank cells in column with consecutive end-of-month dates
Replies
3
Views
86
Fluff
Fluff
H
  • Question
Countifs dates and Reason
Replies
6
Views
77
arthurbr
arthurbr
H
  • Question
Formula to Extact month and year in Textt after "to" in the text
Replies
3
Views
37
etaf
etaf
L
  • Solved
Date sequencing formula - earliest of next Sunday and month end
Replies
8
Views
98
Dossfm0q
D

Watch MrExcel Video

Stacked & Clustered - 1091 - Learn Excel Podcast

Forum statistics

Threads
1,118,278
Messages
5,571,280
Members
412,374
Latest member
Nagelgal

Share this page

Top