Excel oquestion how to find the no of employees born in different months using functions in excel?

You can use the EDATE function to quickly add or subtract months from a date. The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument. For example, =EDATE("9/15/19",-5) returns 4/15/19.

Add or subtract dates - Microsoft Support

and

Excel Add Months to Date - Corporate Finance Institute

https://corporatefinanceinstitute.com > Resources
Nov 24, 2022 - Step 2: Use the =EDATE(C3,C5) formula to add the number of specified months to the start date. Where cell C3 is equal to today's date [the TODAY ...

How to Add Months to Date in Excel (Easy Formula)

https://trumpexcel.com > add-months-to-date-excel
Add Months to a Date · start_date - the date for which you want to get a certain number of months before or after it · months - the number of months before or ...

Add months to date - Excel formula ' Exceljet

https://exceljet.net > Formulas
To add a given number of years to a date, you can use the EDATE function. In the example shown, the formula in D5 is: =EDATE(B5,C5)

The method is influenced by the software and printer being used as well as the access granted to the person using the program.

If you are using an Excel or Calc spreadsheet, you can select the area to be printed.

https://www.wikihow.com/Print-Part-of-an-Excel-Spreadsheet

https://support.office.com/en-us/article/set-or-clear-a-print-area-on-a-worksheet-27048af8-a321-416d-ba1b-e99ae2182a7e

You can preview the area that will be printed prior to printing. And you can definitely change the number of pages you are going to print.

https://hubworks.com/blog/twelve-steps-to-a-microsoft-excel-employee-shift-schedule.html

https://www.betterteam.com/employee-schedule-template#excel-employee-template-schedule-download

Here is a page offering a daily shift scheduling template which may be downloaded for free:

https://www.smartsheet.com/free-daily-schedule-templates

Here are some free employee scheduling programs:

https://fitsmallbusiness.com/best-free-employee-scheduling-software/

Here is an online system:

https://opensimsim.com/

And: https://getsling.com/

Here is a personal shift calendar:

https://www.firehouse.com/shiftcalendar

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Hello this is Baris,
Can you tell me more about this employee. Are you creating an excel spreadsheet to keep record of his days. Are you just getting the numbers from an outside source like a schedule.

To be able to give you an answer I will assume that you have the info already in the same spreadsheet.

Lets say Column A is the days of the month.
Column B is the information column like the hours that the employee worked. If the month has 31 days this is what you need to do.
Click on the cell B32 and type the formula
=count(B1:B31) and press enter. This will count the number off cells which have a value in it in that month.

If you provide me more info we may come up with a better solution. Hope this helps :)

To calculate the difference in Years use =Year(c,r)-Year(c,r)
To calculate the difference in Months use =Month(c,r)-Month(c,r)
To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

There is always multiple solutions, but here is one...

Add a row (that can be hidden later if you want) where you have the full date (01/01/09). For this example it will be row "C." Then use Conditional Formatting with the function:

=weekday(C$2,2)>5.

See if this helps.

The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.

The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.

Read the fine manuals.

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?