C cgx79 Mar 1, 2004 #1 Hi, How to i get the total number of day per month using function not in marco
F Frank Kabel Mar 1, 2004 #2 Hi if A1 contains a date try the following =DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) This returns the n umber of days for the month in A1
Hi if A1 contains a date try the following =DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) This returns the n umber of days for the month in A1
P Peo Sjoblom Mar 1, 2004 #3 This ingenuous formula by Daniel Maher does it =32-DAY(A1-DAY(A1)+32) where the date is in A1
2 2rrs Mar 1, 2004 #4 cgx79 said: Hi, How to i get the total number of day per month using function n not in marco. Message posted Click to expand... you coulld try this also: =DAY(EOMONTH(A72,0))
cgx79 said: Hi, How to i get the total number of day per month using function n not in marco. Message posted Click to expand... you coulld try this also: =DAY(EOMONTH(A72,0))
