Previous Topic Next Topic

Date Function using if_ else statement

Closed
shiny thomas Posts 1 Registration date Thursday December 12, 2013 Status Member Last seen December 12, 2013 - Dec 12, 2013 at 12:47 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 15, 2013 at 12:01 AM
My requirement is while writing a function using if statement :


In a range of cells in say: P10: P20, containing dates, I want to write a function using if statement whereby the result will display 1, if there are dates coming in december'13 month else the result will be zero.

i tried the function as below:- IF($P13 =MONTH(12),1,0) but the result is showing zero for all the range even if there are dec'13 dts.

please provide a solution.

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 15, 2013 at 12:01 AM
how are dates entered in col. P. it should be excel date (u can format as you like).

then use month and year function .
0

Similar discussions

If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses