Dates from an IF statement

Closed

Ian - May 13, 2016 at 08:08 AM
Ian - May 14, 2016 at 02:50 PM

Hello,

I ve selected some dates via a simple if statement and can see the dates in the cell where I want them. But when I try to use them in another formula it doesn't recognise them as dates regardless of how I try to format them. Can anyone help?

I get the date from one of two columns of dates with:
=IF(H623="",R623,"")
then try to use them with:
=SUMIFS(Spend_Tracker!N141:N10138,Q141:Q10138,Q261,S141:S10138,"=Sep-15")

thanks

Dates from an IF statement
Fenix internet on bank statement - Guide
Application for bank statement sbi - Guide
Excel if statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Different dates of "end to end encryption message" on blank chat? - Excel Forum

1 response

Answer 1 / 1

Blocked Profile
May 13, 2016 at 03:04 PM

Are you trying to sum the dates?

Ian
May 14, 2016 at 02:50 PM

no I have sumif that sums a different column based on the date column. But I needed it to choose all of a month so formatted my date column as mmm-yy. But it wouldn't return any value. So I used =TEXT(S22,"mmm-yy") to convert the date column and now the lookup recognises it and works,

Similar discussions

encryption message several time in chat

IF statements with dates and criteria

blank white page for website

using web browser page loads but screen blank

Removing " false" value in "IF"

Similar discussions

Subscribe To Our Newsletter!