Hello Mr Excel,
I have a calendar that setup to look like a calendar. I need a normal look formula that could find the first day and the last day of an event.
<colgroup><col span="9"><col></colgroup><tbody>
</tbody>
I have a calendar that setup to look like a calendar. I need a normal look formula that could find the first day and the last day of an event.
sun | mon | tue | wen | thu | fri | sat | look up | a | |
26-Aug | 27-Aug | 28-Aug | 29-Aug | 30-Aug | 31-Aug | 1-Sep | first day | | |
a | a | b | a | a | a | a | last day | | |
a | a | d | c | c | c | c | |||
31-Aug | 1-Sep | 2-Sep | 3-Sep | 4-Sep | 5-Sep | 6-Sep | | ||
e | e | b | e | e | e | e | |||
e | e | e | e | e | e | a | |
<colgroup><col span="9"><col></colgroup><tbody>
</tbody>