Question about Microsoft Excel for PC

1 Answer

Functions if enter a date 01-02-08  the last date of the month .in excell this formuloa is eomonth()

Posted by on

  • pitchi Mar 09, 2008

    Thank you very much but in access how iget the last day of the month   please  

  • pitchi Mar 09, 2008

    it is very hep full thank you

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 35 Answers

The eomoth function returns the last day of the month.
Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

eomonth (1/2/08, 1) will return 31. The number of days in the month.

eomonth (1/2/08, 2) will return 59, The number of days in the month plus the next month (February)

Posted on Mar 06, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I need a formula length of service in DD/MM/YY on MS Excell


Format cells A1 and B1 to dates.

A1 is the first date
B1 is the 2nd date
C1 enter the formula below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

rootmailsd.jpg

Jun 23, 2011 | Microsoft Excel for PC

1 Answer

I am trying to automatically generate serial numbers in a excel spreadsheet. I have three columns: column A is a date code under the YWW format, column B is the first serial number 00001, and column C is...


Hi JK,
We have to use the combination of dynamic list and indirect() function.
and offcourse countif() and if().

If you need the solution from me, Please send me the sample sheet on ali_zulfikar@yahoo.com so that I can send you the solution sheet.

Zulfikar Ali

Apr 06, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

Date


You can set the date and time from the control panel:

1) Press <Menu>

2) Press arrows select "Initial Setup" Press <OK>

3) Press arrows select "Date and Time" Press <OK>

4) Use numbers to enter year - last two digits <OK>

5) Use numbers for month, <OK>

6) Use numbers for day, <OK>

7) Use numbers for time - 24 hour format, press <OK>

8) Press <Stop/Exit> to return to normal function

Feb 02, 2010 | Brother MFC 240C All-In-One InkJet Printer

1 Answer

Cannot set date & time on Panafax UF-895


To set the date and time, do the following:
  1. Press function 7
  2. Press 1
  3. Press SET
  4. Enter date and time using 2 digits for month (sept 09)
  5. Enter 2 digits for Date
  6. Enter 4 digits for year
  7. Enter 4 digits for time (military time ex: 3pm 1500)
  8. Press SET
  9. Press STOP
The date and time are now set. Best of luck.
Greg

Aug 24, 2009 | Panasonic Panafax UF-595 Plain Paper Laser...

1 Answer

How do I change the date and time on Panafax UF-770


To change the Date/Time, do the following:
  1. Press Function key
  2. Press 7
  3. Press 1
  4. Press COPY/set
  5. Enter date (2digits)
  6. Enter month (2 digits)
  7. Enter year (4 digits)
  8. Enter time (4 digits military time)
  9. Any mistakes can be corrected using the < > arrow keys to place cursor over the character to change.
  10. Press COPY/set
  11. Press STOP
This should answer your question. All the best.
Greg

Jul 21, 2009 | Panasonic Panafax UF-595 Plain Paper Laser...

1 Answer

What is the formula,if a cell having start date of some batch, and i f i need to calculate the end date after 15 month ?


Use this forumla =EDATE(A1,15)

example in cell A1 you enter 3/11/2009 and in cell A3 you enter=EDATE(A1,15)

You will first see a serial number representing the new date. You must format cell A3 to display the value as a date. it should be:
6/11/2010

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Procedure how to establish aging of account receivable in excel


Once your data has been input into Excel - I assume you can do this via importing an outstanding debtors deport.

The easiest way I can see is by Pivot Table.

Your data should include open invoices and their respective due dates, it will be easier if you could covert these due dates into months - Create a pivot entering customer, outstanding values as your data and due months as your range.

Feb 22, 2009 | Microsoft Computers & Internet

1 Answer

Converting date of a month to last working day of the month


use the below formula to get the date of the LWD (Monday thru Friday) of the month.
Assumed that if the date in cell A1 is 6-May-2005. then formula will be
=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Jan 30, 2009 | Microsoft Excel for PC

2 Answers

Formula for calculating the days beween months


for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

1 Answer

Access


There is no function to do this as part of a whole suite of date manipulation functions, but I seem to have imagined that, as I couldn’t find. I was dreading having to do lots of nasty date arithmetic, but then I discovered that the zeroth day of a month is treated as the last day of the previous month! So the last day of the month for the date that’s in cell B3 is simply:
=DATE(YEAR(B3), MONTH(B3)+1, 0)
It even works across year boundaries, so DATE(2004, 13, 0) really does give

Mar 11, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel for PC Logo

106 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...