Forum Discussion
dvyes
Feb 10, 2020Copper Contributor
formatting a cell for specific purpose
I am preparing a family details table, where in columns are created for entering actual dates of birth and wedding anniversary. Now I wish to open new columns to highlight birthdays or wedding a...
Riny_van_Eekelen
Feb 10, 2020Platinum Contributor
dvyes You could add two columns and enter:
=MONTH(cell)
In one column you point to d.o.b., in the other to the anniversary. The picture below demonstrates the principle. Now you can filter on month.
dvyes
Feb 10, 2020Copper Contributor
Hi, I dont know whether my message conveyed correctly what I meant. I am attaching a table and want the cells marked ???? to be formatted, so that it acts as remainder for birthday or wedding anniversary in any year.
| Ist Generation | 2nd Generation | 3rd Generation | Date of Birth | AGE | Wedding Date | No. of yrs of marriage | Mobile Number | BIRTHDAY | WEDDING ANNIVERSARY |
| Devendra Kumar V Shah | 3-Aug-1950 | 69 | 11-Feb-1976 | 43 | 95900 25888 | ??? | ???? | ||
| Rekha D Shah | 10-Aug-1951 | 68 | 11-Feb-1976 | 43 | 93412 55287 |