Previous Topic Next Topic

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


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
measking -
HelpiOS -

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

1 response
using web browser page loads but screen blank
inchoate -
leo -

16 responses
using nested if to blank out adjacent cells
WILLYB -
mubashir aziz -

3 responses