ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   date formula (https://www.excelbanter.com/excel-discussion-misc-queries/136370-re-date-formula.html)

deepak bsg[_2_]
date formula
 
Thank you very much

"Stefi" wrote:

Try this formula:
=IF(D1<DATE(2005,4,1),1,IF(D1<DATE(2006,4,1),2,3))

Regards,
Stefi

€ždeepak bsg€ť ezt Ă*rta:

i have data with date commissionings of last four years. I want to take them
as, before 01/04/2005 as 1, and in between 01/04/05 to 01/04/2006 as 2 and
after 01/04/2006 as 3. when i'm using datevalue() using if it is satisfying
some conditions only.
can any one help ? I need urgently .

Stefi
date formula
 
You are welcome! Thanks for the feedback!
Stefi


€ždeepak bsg€ť ezt Ă*rta:

Thank you very much

"Stefi" wrote:

Try this formula:
=IF(D1<DATE(2005,4,1),1,IF(D1<DATE(2006,4,1),2,3))

Regards,
Stefi

€ždeepak bsg€ť ezt Ă*rta:

i have data with date commissionings of last four years. I want to take them
as, before 01/04/2005 as 1, and in between 01/04/05 to 01/04/2006 as 2 and
after 01/04/2006 as 3. when i'm using datevalue() using if it is satisfying
some conditions only.
can any one help ? I need urgently .


All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com