Return (indication of) Birthday between date periods

Hi,

Am looking for suggestions as to how to indicate someone's birthday (column C) from within a list of start dates (column A) and end dates (column B). i.e. would it be best to create a list based on the date of birth and then do a conditional column?

For example date of birth is 12/09/1968. Thus birthdays are 12/09/1969, 12/09/1970 etc. The start dates / end dates (as shown in dd/mm/yyyy format) might be as follows:


Therefore:
08/09/2016 > 22/09/2016 is a birthday period. Similarly 26/07/2018 > 09/10/2018.


Thanks in advance!
SP

Hi and welcome
do you need PQ for this?

Hello, Yes my preference is PQ due to sheer volume of data rows. I have tried splitting the birthdate by dd, mm, yy in separate columns. Then merging dd and mm back together. Thus adding in the year to this from the start date (splitting also.) Thus doing a conditional column on bithday year vs start date and end date. Seems to work. Would be happy to see if anyone has any other (more elegant) suggestions Thanks!

Sanpeur said:

Would be happy to see if anyone has any other (more elegant) suggestions Thanks!

Click to expand...

Well. nearly 2 years later, here's an offering attached; it may be 'elegant'-ish in terms of output, but I suspect the code behind it is anything but.
I'm trying to learn M code and would welcome criticism and improvements, especially in the 2nd half of the fnHasABday function.