ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

3 Q & A posts tagged with DAY

Mon
Nov 14
2011

How do I write a formula in Excel to figure out age and then if older?

Here is my question:
How would I a write a formula that figures out someone's age and then checks if that age is greater than 55? I know the birth date but am not sure on how to formulate. Nested function, if so how?


Answer

One if should do the trick
Assuming the birth date is on cell A1, paste this in B1
=IF( TODAY()-A1>55*356, "Older than 55", "Younger than 55")

let me know if this helped

Monday 11/14/2011 6:06:28 AM
Mon
May 3
2010

Any microsoft excel experts here? need excel formula please help?

i know i asked this before but i never got a formula and i am still looking

i am looking for an excel formula in which i can add exactly one month to the month thats on the left of it on the previous row.

for example

Date Date
12/27/10 1/27/10

the second one i wish to show up automatically,

i know that it would be something like this:
=DATE(YEAR(C13), MONTH(C13)+1, DAY(C13))

but i am looking for a formula for the entire column so that i do not have to add the formula to each individual cell

thank you in advance


Answer

Just Copy and Paste that cell (with formula) to the cells below

VBAXLMan

Monday 5/3/2010 8:23:46 AM
Sat
Apr 4
2009

Microsoft Office Excel 2007 counting months?

example
how do i count the amount of months i have been employed
i want the worksheet to update automatical everytime i open it, no static values

Start Date =DATE(2007,8,22)
Today Date =TODAY()
Months
Days =B8-B7 = 592

whats the formula to count the months..is there a easy way
any help much appreciated...thanks


Answer

Based on how you want to show the number of months (Integers or parts) you got several options:
1- do this in any cell
=(B8-B7)/30
This will give you how many 30 days this period has

2- You also do this
=INT(( B8-B7).30)
To get how many full months

VBAXLMan

Saturday 4/4/2009 1:34:45 PM

Tags

History