User Profile
Bob_lponge
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Formatting default 21/01/1900 date
I have a sheet where it is formatted with the below formulas. When a sent date is to be completed within 7 days the text turns red, when it is to be completed within 14, the text turns amber. However when typing in any row, the text always appears as red and the column shows the default as 21/01/1990 when dragging the formula down. Is there a way to have the default text black unless those ranges are met and to have the columns appear as blank rather than with the default 21/01/1900 format date? Formulas used are: =$A2-TODAY()<=7 =$A2-TODAY()<=14Due dates
Is there a way to have a due date column which updates daily or whenever an excel sheet is opened? For example a client has 21 days to make a return of a parcel from a specified date. Is it possible to have a column which essentially counts down these days and also turns the row amber when there are 14 days remaining to make the return and red when there are 7 days remaining to make the return?Finding duplicates
Is there a way to find duplicates based on initials and date of birth? For example: Joe Bloggs 16/01/1977 Susan Smith 14/4/1987 Brian Red 07/08/1957 Jake Boss 16/01/1977 So a formula that would highlight Joe Bloggs and Jake Boss as potential duplicates? Due to the J, B and date of birth matching?
