| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last day of the month
Dear all
I have in sheet 1 an input date from a user. I want to run in another sheet (let's say sheet2) based on that day the last date of the month in order to make some calculations i need. eg. input form user in A1 14/03/2002 - to be in B1 31/03/2002 Any suggestions? Thanks in advance manos |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Last day of the month
use function EOMONTH.
for example, =EOMONTH(Sheet1!A1,0) will return the last day of the month. Hope this helps!! -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Manos" wrote: Dear all I have in sheet 1 an input date from a user. I want to run in another sheet (let's say sheet2) based on that day the last date of the month in order to make some calculations i need. eg. input form user in A1 14/03/2002 - to be in B1 31/03/2002 Any suggestions? Thanks in advance manos |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Last day of the month
=Date(Year(Sheet1!A1),Month(Sheet1!A1)+1,0)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Manos" wrote in message ... Dear all I have in sheet 1 an input date from a user. I want to run in another sheet (let's say sheet2) based on that day the last date of the month in order to make some calculations i need. eg. input form user in A1 14/03/2002 - to be in B1 31/03/2002 Any suggestions? Thanks in advance manos |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Last day of the month
Thank you
"Manos" wrote: Dear all I have in sheet 1 an input date from a user. I want to run in another sheet (let's say sheet2) based on that day the last date of the month in order to make some calculations i need. eg. input form user in A1 14/03/2002 - to be in B1 31/03/2002 Any suggestions? Thanks in advance manos |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| Create Month Timetable on a worksheet different month each works | Excel Worksheet Functions | |||
| copy worksheet from previous month and rename to current month | Excel Programming | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Hybrid Mode
