| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Days in a month as of today
I need a formula that will look at today's date, figure out the days in the
month and then in a different cell give me the number of days so far in that month. ie - A1 = 1/1/07 B2 = [(DAY(DATE(YEAR(A1),MONTH(A1)+1,0))] = 31 B3 = should come up with 25 since today is Jan 25 Thx, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Days in a month as of today
Hi Daniel
Try =DAY(TODAY()) -- Regards Roger Govier "Daniel Q." wrote in message ... I need a formula that will look at today's date, figure out the days in the month and then in a different cell give me the number of days so far in that month. ie - A1 = 1/1/07 B2 = [(DAY(DATE(YEAR(A1),MONTH(A1)+1,0))] = 31 B3 = should come up with 25 since today is Jan 25 Thx, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Days in a month as of today
B2: =DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
which is what you had without the square brackets B3: =DAY(TODAY()) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Daniel Q." wrote in message ... I need a formula that will look at today's date, figure out the days in the month and then in a different cell give me the number of days so far in that month. ie - A1 = 1/1/07 B2 = [(DAY(DATE(YEAR(A1),MONTH(A1)+1,0))] = 31 B3 = should come up with 25 since today is Jan 25 Thx, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
| i have two days and i want the difference in days, months, year | Excel Worksheet Functions | |||
| amount of working days per month | Excel Discussion (Misc queries) | |||
| 4 and 5 week months | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Linear Mode
