I need day in another row beside to date row
Suppose like a1=date b1 should get day and for this any formula can be applied.Please mention anybody.
For example
A1 B1
6/9/2012 THURSDAY How to get through formula
Hai,
I needed total sum of number of pages corresponding to date-wise.
DATE ARTICLES NO. PAGES TOTAL
4-Sep-12 PJ2012143 20
NC201253 30
SC201298 32
5-Sep-12 PJ2012143 18
NC201253 32
SC201298 18
for example: In 4Sep, no of pages=82, so i need this to be done by applying...