G Guest Mar 18, 2004 #1 How do I get Excel to put in the date at the end of the month? (So I can calculate invoice amts owing)
How do I get Excel to put in the date at the end of the month? (So I can calculate invoice amts owing)
F Frank Kabel Mar 18, 2004 #2 Hi if A1 stores a date use =DATE(YEAR(A1),MONTH(A1)+1,0) Or for the current month use =DATE(YEAR(NOW()),MONTH(NOW())+1,0) -- Regards Frank Kabel Frankfurt, Germany Tony said: How do I get Excel to put in the date at the end of the month? (So I Click to expand... can calculate invoice amts owing)
Hi if A1 stores a date use =DATE(YEAR(A1),MONTH(A1)+1,0) Or for the current month use =DATE(YEAR(NOW()),MONTH(NOW())+1,0) -- Regards Frank Kabel Frankfurt, Germany Tony said: How do I get Excel to put in the date at the end of the month? (So I Click to expand... can calculate invoice amts owing)
