| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating how many days past in a month from today
Hi everybody,
Is there any way to calculate days past in a month from the date calculated by today function? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating how many days past in a month from today
Perhaps with
=DAY(TODAY()) greetings "Arup C" schreef in bericht ... Hi everybody, Is there any way to calculate days past in a month from the date calculated by today function? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating how many days past in a month from today
Frederik said:
Perhaps with =DAY(TODAY()) greetings That's useful to know. If I wanted to know the number of days remaining in the month (bearing in mind months can be 30, 31, 28 or even 29 days long), how could we do that? DC -- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating how many days past in a month from today
Hi
For days past (therefore not including today, use =DAY(TODAY())-1 -- Regards Roger Govier "Arup C" wrote in message ... Hi everybody, Is there any way to calculate days past in a month from the date calculated by today function? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating how many days past in a month from today
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-TODAY()
-- Kind regards, Niek Otten Microsoft MVP - Excel <Django Cat wrote in message o.uk... | Frederik said: | | Perhaps with | | =DAY(TODAY()) | | greetings | | | That's useful to know. If I wanted to know the number of days remaining in the month (bearing in mind months can be 30, 31, 28 or even 29 days long), how could we do that? | DC | | -- | |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating how many days past in a month from today
Niek Otten said:
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-TODAY() Thanks, that works! DC -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Days per month for calculating storage days | Excel Worksheet Functions | |||
| Days in a month as of today | Excel Worksheet Functions | |||
| count if gone past today | Excel Discussion (Misc queries) | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| Calculating days in a month | Excel Discussion (Misc queries) | |||
![Arup C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
