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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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
24
BiggusDoggus
B
F
  • Solved
Fill blank cells in column with consecutive end-of-month dates
Replies
3
Views
47
Fluff
Fluff
H
  • Question
Countifs dates and Reason
Replies
6
Views
47
arthurbr
arthurbr
N
  • Question
extracting month and year from column of dates
Replies
8
Views
150
Nova1979
N
J
  • Locked
  • Question
Inserting rows with entry of month and dates of two given months
Replies
1
Views
50
jasonb75
J

Watch MrExcel Video

Excel Number The Visible Rows - 2328

Forum statistics

Threads
1,112,880
Messages
5,543,007
Members
410,583
Latest member
gazz57

Share this page

Top