- Messages
- 7
- Reaction score
- 4
- Points
- 3
This might have been asked a few times but on Wednesday my puppy was 20 weeks old as he was born on the 05/04/23 but does that mean he's now 5 months old or would that be on the 05/09/23?
The Most Dog Friendly Community Online
Join and Discover the Best Things to do with your Dog
Dog age
- Thread starter Michelle1982
- Start date
- Messages
- 5,674
- Reaction score
- 5,268
- Points
- 113
Assuming you are using the UK date formation and not the USA one, if your puppy was born on the 5th of April he will be five months old,on the 5th of September.
- Messages
- 2,369
- Reaction score
- 1,904
- Points
- 113
If you are talking about calendar months, he will be 5 months old on 5th September. There are 12 calendar months in one year, if you are talking about weeks there are 13 x 4 weeks in one year. We do not have 13 calendar months in 1 year
- Messages
- 2,487
- Reaction score
- 2,243
- Points
- 113
I've just been messing around with Excel, pop this formula in to calculate age, where N23 is a cell with the DOB entered:
=IF(N23="","",(DATEDIF(N23,TODAY(),"y")&" years, "&DATEDIF(N23,TODAY(),"ym")&" months, "&DATEDIF(N23,TODAY(),"md")&" days"))
A better Excel user than me will likely to be able to slim that formula down a bit! Anyway, the result I got for your dog was 0 years, 4 months, 21 days as of today.
=IF(N23="","",(DATEDIF(N23,TODAY(),"y")&" years, "&DATEDIF(N23,TODAY(),"ym")&" months, "&DATEDIF(N23,TODAY(),"md")&" days"))
A better Excel user than me will likely to be able to slim that formula down a bit! Anyway, the result I got for your dog was 0 years, 4 months, 21 days as of today.
