Question about Microsoft Excel for PC

1 Answer

Formula for Date

I have a attendance data, this data doesnt show a date if employee is absence or doesnt swap a Card. How I can get the missing date with the dates which I have available atleast I should get the start date for each employee as 26 of every month

Posted by on

  • dilpradhan Nov 22, 2008

    how can I used page maker as i am a new user

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 48 Answers

Make that column fixed and give the variable date and value 26/Month of year/year

That is the logic Can you do that

Fixya?

Posted on Apr 01, 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

Time and date shows on the screen but not on the memory card - how do i get the photos off with the time and date on the photo with time and date from the memory card?


The date and time (and a lot more) are stored with every picture in its EXIF metadata. Any photo viewing/editing program should be able to display this data. To print this data, please consult the documentation for whatever program you're using to print your pictures. Depending on the program and printer you may print the date on the image, in the margins, or on the back.

Jun 07, 2011 | Canon PowerShot SX100 IS Digital Camera

1 Answer

How do i change the time


The time and date are programmed through system programming. A 4015 phone cannot do this programming. A 4150 phone setup as a subattendant phone with the "attendant setup time/date" class of service option enabled for the 4150's class of service can change the system time and date. This is accessed through the LCD touch screen keys of the 4150. Scroll through the options in the screen until you find set time /date.
Also an attendant console with the "attendant setup time/date" class of service option enabled for its class of service can change the time and date. Press the function button then choose attendant function.
Choose set time. Enter the time in four digits as in 0800 for 8:00. Choose PM if needed. Choose set.
Choose exit to finish.

Dec 13, 2010 | Mitel Superset 4015 Corded Phone

2 Answers

Need to have a certain cell say OFF when it is a certain day


Use the test function.
Formula in cell A1 would be =text(a2,"dddd").
This would pick up the date from cell A2 and return the day of the week in cell A1.

Jun 06, 2010 | Microsoft Excel for PC

1 Answer

MS excel issue


Using a time format for the data cells and data that looks like 12:00:10 AM the result you want is displayed no matter which formula is used. If the date portion of the data cell is not deleted then the result is 00:00:00. Delete the date portion of your data cells to get the result you want. (For example: When I enter 10 into a cell that is formated for time xx:xx:xx it shows 1/11/1904 12:00:00 AM in the formula bar and 00:00:00 in the cell. When I delete 1/11/1904 in the formula bar and show only the 12:00:10 the cell shows 00:00:10. Then it makes no difference which formula you use.)

Sep 19, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

3 Answers

Need excel solution


Hello ycool11, If your asking what i think you are the formula would be
=(a2-a1)*24
That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

Oct 22, 2008 | Microsoft Excel for PC

1 Answer

Finepix A 360 Digital Camera


The date and time (and a lot more) are stored with every picture in its EXIF metadata. Any photo viewing/editing program should be able to display this data. To print this data, please consult the documentation for whatever program you're using to print your pictures. Depending on the program and printer you may print the date on the image, in the margins, or on the back.

Oct 19, 2008 | Fuji FinePix A360 Digital Camera

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:...

2 Answers

Min and Max Date range filter


Check out: Tools -> Data -> Filter -> Auto Filter.
You may want to look at the help function to get a better idea of how powerful this feature is.

Let me know if this helps.

May 08, 2008 | Microsoft Excel for PC

1 Answer

Creating a holiday accrual spreadsheet.


Hi, I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula. However here are some tips: Set up a column with the start date for each employee and use the today() function to get today's date. You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month. For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together. Good luck K

Sep 05, 2007 | Microsoft Office Standard for PC

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

Related Topics:

121 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 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...