| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight birthdays
Hi
With birth date in cell A2 =AND(DATE(YEAR(TODAY(),MONTH(A2),DAY(A2))-TODAY()<15,DATE(YEAR(TODAY(),MONTH(A2),DAY(A2))=T ODAY()) You also can try =AND(DATEDIF(TODAY(),A2,"MD")<15,DATEDIF(TODAY(),A 2)=0,"MD") -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "jocker" wrote in message . nl... Using conditional formatting how would I highlight birthdays coming up within the next 14 days. I can't use < today()+14 since birth year is in the past. I don't mind using VBA if this helps |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight all colums in Bar Graph | Charts and Charting in Excel | |||
| Conditional Format to highlight entrire Row | Excel Worksheet Functions | |||
| highlight cells equals sum, not count | Excel Discussion (Misc queries) | |||
| How can I highlight every other group of data? | Excel Discussion (Misc queries) | |||
| How do I highlight all lookup formulas in a worksheet in one shot. | Excel Discussion (Misc queries) | |||
Threaded Mode
