Hiya,
On the attached sheet I have a page called 'Week' that shows dates. Previously I have been able to match those dates and generate a list with the following formula on page 'Formula'.
=IF(OR(E2=Week!$B$2,E2=Week!$B$3,E2=Week!$B$4,E2=Week!$B$5,E2=Week!$B$6,),COUNT(G$1:G1)+1,"")
For some reason it won't display anything and I'm wondering whether it's to do with the formula it's table it's reading from on page 'Intouch'.
Just as a test I changed the formula in column E of the 'Formula' page to text and the formula worked so it would seem that formula's do affect the outcome.
Consider changing your formula in 'Intouch' tab to
Currently the result is read as text and not as a date, hence the anomaly
=DATE(MID(Table_ReportGenerationDatabase[@EndTime],7,4),MID(Table_ReportGenerationDatabase[@EndTime],4,2),LEFT(Table_ReportGenerationDatabase[@EndTime],2))
Life's a spreadsheet, Excel!
Say thanks, Click *
The formula you are using in the INTOUCH sheet (LEFT...) extracts a text string which you are comparing to a number of the Weeks sheet. Thus it always returns an empty string
Enterin ED2 (then drag down) in the Intouch sheet and format as date. You will see your results now appearing=INT(Table_ReportGenerationDatabase[@EndTime])
Last edited by Pepe Le Mokko; 02-04-2013 at 06:05 AM.
Thankyou both,
Both of those examples have worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks