Dates in an Excel Dbase

  • Thread starter Thread starter wx4usa
  • Start date Start date
W

wx4usa

I have Column A which is the date in MM/DD/YYYY format.

For my database, I need column A converted to the following
columns.....

B Daynumber =IF(A5>0,DAY(A5),"")
C Day of week =IF(A5>0,TEXT(A5,"dddd"),"")
D Month =IF(A5>0,TEXT(A5,"mmmm"),"")
E Year =IF(A6>0,YEAR(A6),"")

I have used the above formulas in columns B-E to do just that, however
when I built a report that calculates the data using sumproduct, it is
VERY slow and sometimes boggs down with just 300 lines/9 columns of
data.

When I build my report and neglect the columns B through E, the data
calculates lightning fast and it calculates with as many as 50,000
lines/9 columns of data not 300.

Something in the way I am converting the date to the other columns eats
up system resources.

How can I fix this? Any ideas?
 
Hi

Show what your Sumproduct formula is, and what data is in any other
columns being used in the formula and maybe someone can help.
 
Back
Top