Dates in an Excel Dbase

[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?

 

[Roger Govier]

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.