estimate dateofbirth

dear friends,

I have a database where there is 'date of admission' of patients available. these patients do not know their date of birth. they have provided their estimated age in days or months or years. I would like to have a formula by which i can assign a 'date of birth' to each of them. this 'date of birth' will of course be a rough estimate and can be 1st day of the nearest month. it would allow me to then use the two columns ('date of birth' & 'date of admission') to perform various calculations.

for eg., if someone says today that their age is 5 years, their estimated 'date of birth' would be 01/02/2009 (01 =first day of month; 02 = the present month - feb, 2009 = 5 years from now which is 2014).
i would be grateful if you could please provide either a formula or macro.

thanks.

OK, for the example given one could use

Please Login or Register  to view this content.

you could susbtitute the 5 for a cell reference containing the supposed age

thanks. unable to fully understand. can u pl give me a worked example? suppose a patient arrived on 01/02/2010 and gave age as 75 years - how to insert this information into your formula? if same patient gave age as 5 months, how to insert? if gave age as 25 days, how to insert?

thanks.

Got it! Thanks very much.

@popipipo is absolutely right!!!