Hi all,
I have 2 columns, col A: Date with time i.e.(21 Oct 06 11:34)
col B: Manually inputted Day i.e.(Sun)
The range is from 01st Jan to 30th Sept, but this will be ongoing.
Is it possible to automate (col B)the Day from info in col A?
Can I also count the number of say Sundays in a given range, say last quarter. Would this also be possible with the time. I am wanting to do this to help with problem solving.
I have spent many a frustrated hour trying to get my head around this, any help will be most welcome.
Steve
I have 2 columns, col A: Date with time i.e.(21 Oct 06 11:34)
col B: Manually inputted Day i.e.(Sun)
The range is from 01st Jan to 30th Sept, but this will be ongoing.
Is it possible to automate (col B)the Day from info in col A?
Can I also count the number of say Sundays in a given range, say last quarter. Would this also be possible with the time. I am wanting to do this to help with problem solving.
I have spent many a frustrated hour trying to get my head around this, any help will be most welcome.
Steve