| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 8982 | 2001-04-29 06:30:00 | Excel ...Giving Mon-Sun a day value | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 11968 | 2001-04-29 06:30:00 | Ive done this before, Monday = 1, Tue = 2 etc.. but forgotten the formula. Ive looked up my Function Reference book, no luck there under Day or Value. Thanks in anticipation....John Oh, if you know how I can get one cell in my 5pg worksheet, to update the date, but only on a Monday, please let me know. Cheers....John jhw@xtra.co.nz |
Guest (0) | ||
| 11969 | 2001-04-29 09:28:00 | The function WEEKDAY will return the day of the week - starting with Sunday = 1. The following formula will show from Monday to Sunday as Monday's data then roll over on the next Monday. =IF(WEEKDAY(NOW())=3,NOW()-1,IF(WEEKDAY(NOW())=4,NOW()-2,IF(WEEKDAY(NOW())=5,NOW()-3,IF(WEEKDAY(NOW())=6,NOW()-4,IF(WEEKDAY(NOW())=7,NOW()-5,IF(WEEKDAY(NOW())=1,NOW()-6,NOW())))))) HTH |
Guest (0) | ||
| 11970 | 2001-04-30 10:21:00 | Thanks Russel, work well. Cheers....John |
Guest (0) | ||
| 1 | |||||