Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm looking for a formula to calc # of days left in a month
I am trying to set up a formule that will show show the the date of the first
of each month from a date from another cell. For example. In cell a1 I enter and arbitrary date, let say 7/1/06. In cell C1, the formula calculates the day left in the month and shows the first date of the next month, for example 8/1/06. then in cell D1, the formula calculates the date of the next month, for example 9/1/06. Is there such a formala? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm looking for a formula to calc # of days left in a month
Hi,
try = Date(year(a1),month(a1)+1,1) hope this helps Regards from Brazil Marcelo "Manthony" escreveu: I am trying to set up a formule that will show show the the date of the first of each month from a date from another cell. For example. In cell a1 I enter and arbitrary date, let say 7/1/06. In cell C1, the formula calculates the day left in the month and shows the first date of the next month, for example 8/1/06. then in cell D1, the formula calculates the date of the next month, for example 9/1/06. Is there such a formala? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm looking for a formula to calc # of days left in a month
Manthony --
If today's date is in A1 (perhaps as =today()), then try B1 =EOMONTH(A1,0)-A1 C1 =EOMONTH(A1,0)+1 D1 =EOMONTH(A1,1)+1 etc. Cell B1 will show the number of days until the end of the month, and C1, D1, etc will show the first day of successive months. HTH "Manthony" wrote: I am trying to set up a formule that will show show the the date of the first of each month from a date from another cell. For example. In cell a1 I enter and arbitrary date, let say 7/1/06. In cell C1, the formula calculates the day left in the month and shows the first date of the next month, for example 8/1/06. then in cell D1, the formula calculates the date of the next month, for example 9/1/06. Is there such a formala? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm looking for a formula to calc # of days left in a month
Thank you very much.
This formula works perfectly. Manthony "Marcelo" wrote: Hi, try = Date(year(a1),month(a1)+1,1) hope this helps Regards from Brazil Marcelo "Manthony" escreveu: I am trying to set up a formule that will show show the the date of the first of each month from a date from another cell. For example. In cell a1 I enter and arbitrary date, let say 7/1/06. In cell C1, the formula calculates the day left in the month and shows the first date of the next month, for example 8/1/06. then in cell D1, the formula calculates the date of the next month, for example 9/1/06. Is there such a formala? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of days left in the Month? | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
need help with formula | Excel Discussion (Misc queries) | |||
formula: First and last day in month | Excel Worksheet Functions |