How can I return a number of days in a given month
J John Vinson May 22, 2004 #2 How can I return a number of days in a given month Click to expand... DateDiff("d", DateSerial(Year([enter a date:], Month([enter a date:], 1), DateSerial(Year([enter a date:], Month([enter a date:] + 1, 0)
How can I return a number of days in a given month Click to expand... DateDiff("d", DateSerial(Year([enter a date:], Month([enter a date:], 1), DateSerial(Year([enter a date:], Month([enter a date:] + 1, 0)
V Van T. Dinh May 22, 2004 #3 If you want the current month: ?Day(DateSerial(Year(Date()), Month(Date()) + 1, 0)) 31 If you want the number of days of the month of a specific date, replace Date() with the input date.
If you want the current month: ?Day(DateSerial(Year(Date()), Month(Date()) + 1, 0)) 31 If you want the number of days of the month of a specific date, replace Date() with the input date.
S sol May 24, 2004 #4 imbackd said: How can I return a number of days in a given month Click to expand...
