Fuction that gives number of days of a given month
I am just wondering if there is a function that gives you the number days of
the month for a given date. Thanks |
Fuction that gives number of days of a given month
Assuming that A1 contains a date, such as 2/15/06, try...
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) Hope this helps! In article , "FGOMEZ" wrote: I am just wondering if there is a function that gives you the number days of the month for a given date. Thanks |
Fuction that gives number of days of a given month
Hi
With Analysis Toolpack installed =DAY(EOMONTH(YourDate,0)) Without Analysis Toolpack =DAY(DATE(YEAR(YourDate),MONTH(YourDate)+1,0)) Arvi Laanemets "FGOMEZ" wrote in message ... I am just wondering if there is a function that gives you the number days of the month for a given date. Thanks |
Fuction that gives number of days of a given month
It helped really well.
Thanks so much Domenic "Domenic" wrote in message ... Assuming that A1 contains a date, such as 2/15/06, try... =DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) Hope this helps! In article , "FGOMEZ" wrote: I am just wondering if there is a function that gives you the number days of the month for a given date. Thanks |
All times are GMT +1. The time now is 07:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com