=(TODAY()-A1)/365 - Wrath of the Barclay

=(TODAY()-A1)/365

where cell A1 is the age.

Fix the decimal place to 0 on the cell you putting it into.

Posted By: Rivers_Wonderland on August 22nd 2005 at 12:24:43

Message Thread

Excel help needed (General Chat) - Dave in France, Aug 22, 12:08:41
- =(TODAY()-A1)/365 (General Chat) - Rivers_Wonderland, Aug 22, 12:24:43
  - i don't have d.o.b. all in one cell (General Chat) - Dave in France, Aug 22, 12:36:15
    - so when you said.... (General Chat) - Tricky Hawes, Aug 22, 12:48:12
      - i wasn't being stroppy (General Chat) - Dave in France, Aug 22, 13:03:31
  - surely A1 is the date of birth? (n/m) (General Chat) - mr carra, Aug 22, 12:27:04
    - sorry, you beat me to it anyway (n/m) (General Chat) - mr carra, Aug 22, 12:27:27
  - Corection: wehere cell A1 is the date of birth (n/m) (General Chat) - Rivers_Wonderland, Aug 22, 12:26:11
- =TODAY() (n/m) (General Chat) - mr carra, Aug 22, 12:20:36
  - thanks (General Chat) - Dave in France, Aug 22, 12:28:30
    - YEAR(TODAY()) (n/m) (General Chat) - roywallerslovechild, Aug 22, 12:57:34
      - A small suggestion (General Chat) - Winged Eel Creosote, Aug 22, 13:01:31
        
        I am naturally helpful though. I can forgive Dave for having gone native. (n/m) (General Chat) - roywallerslovechild, Aug 22, 13:03:11
      - im not typing it again (n/m) (General Chat) - pants, Aug 22, 13:00:46
        
        Maybe once was one too many? (n/m) (General Chat) - roywallerslovechild, Aug 22, 13:04:40
- typr "Calculate the difference between two dates" (General Chat) - WOTB No1 Tipster 04, Aug 22, 12:13:11

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.