| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Date to Age
I have been asked to create a report that allows for both age and/or
birthdate. Well if I have the age, the report works fine, however there are some instances that I only have the birthdate, how would I convert that date to age in the vba application and populate it into the age field. Same text is Column 2, row 2 is birthdate, column 2, row 3 is age I am assuming that an if...else loop would apply, but can't seem to get it working. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert US date with 12hr format to European date 24hr | Excel Discussion (Misc queries) | |||
| How to convert Gregorian date into Hijri Date in Excel 2007? | Excel Discussion (Misc queries) | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
| Convert Date Time in Spreadsheet Column to Date only | Excel Programming | |||
Threaded Mode
