Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Newsgroup,
I need a code which automatically gives me the number of days from the current month (e.g. 31 in January, 28 in February a.s.o.)... some days before, I got the following code: Day(DateSerial(Year(Date), Month(Date), 0)) But the problem is that this gives back "31" even today - when "28" would have been very much better ;o) Does anyone have a better idea? Thanks in advance and best regards Markus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rolling chart to show 13 months back from current month | Charts and Charting in Excel | |||
How to give back a value, based in another table? | Excel Discussion (Misc queries) | |||
Saving file as current month name automatically | Excel Discussion (Misc queries) | |||
automatically update chart plotting current month and previous 6 | Charts and Charting in Excel | |||
Do you give memory back? | Excel Programming |