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

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.
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
38
etaf
etaf
L
  • Solved
Date sequencing formula - earliest of next Sunday and month end
Replies
8
Views
99
Dossfm0q
D

Watch MrExcel Video

Learn Excel - Add Mean to Bell Curve - Podcast #1825

Forum statistics

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

Share this page

Top