| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 2 | 1998-09-01 00:11:00 | Birthdays in Microsoft Works | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 84 | 2002-08-31 01:09:00 | Rather than work out years and months, why not just convert the date to a number? I haven't used Excel for a while, but I know that each date is assigned a number starting with 1 Jan 1900 = 1. I think it even goes as far as hours and minutes, eg. midday 2 Jan 1900 = 1.5. Therefore, it would innumerably easier to get the date serial and compare that to today's date. Actually, I think it's called DateSerial(Date). So, the formula would be something like: =IF(ABS(DATESERIAL(TODAY())-DATESERIAL(Susan's_date&month_only_birthday_cell))<8,true_statement,false_statement) |
antmannz (28) | ||
| 85 | 2002-08-31 01:19:00 | Ummm .... hang on, just realised that's all a load of garbage, it converts to numbers automatically & today() takes no account of years. Acckk :( | antmannz (28) | ||
| 86 | 2002-08-31 01:37:00 | AH HA !! Susan, the easiest formula is: =DATEDIF(TODAY(),full_birthdate_including_year,"yd") Change the colour of the cells based on whether the above formula produces a result of less than 7 or greater than 358 (to handle those with b/days between 24 Dec and 6 Jan). See more here (www.cpearson.com). |
antmannz (28) | ||
| 1 2 3 4 | |||||