Date Function using if_ else statement

[Closed]
Report
Posts
1
Registration date
Thursday December 12, 2013
Status
Member
Last seen
December 12, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
how are dates entered in col. P. it should be excel date (u can format as you like).

then use month and year function .