Previous Topic Next Topic

Having trouble with macros

Closed
pepeioo Posts 1 Registration date Saturday 22 September 2012 Status Member Last seen 22 September 2012 - 22 Sep 2012 à 12:08
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Sep 2012 à 08:54
Hello,

I need you help please, I want to write the macros something like this:

if x = 1(number of month) and y = 1 then
z = 31(number of the days of first month January)

if x = 2 and y = 1 then
z = 29(February)

if x= 1 and y = 2 then
z = 31 + 29 (Jan + Feb)

w8ing for your answer thanks.

<config>Windows XP / Chrome 21.0.1180.89</config>
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
23 Sep 2012 à 07:21
=IF(A1="",0,IF(OR(A1=1,A1=3,A1=5,A1=7,A1=8,A1=10,A1=12),31,IF(OR(A1=4,A1=6,A1=9,A1=11),30,IF(A1=2,29,0)))) + IF(B1="",0,IF(OR(B1=1,B1=3,B1=5,B1=7,B1=8,B1=10,B1=12),31,IF(OR(B1=4,B1=6,B1=9,B1=11),30,IF(B1=2,29,0))))
pepeioo
24 Sep 2012 à 03:13
thanks for this formula but it is not exactly the formula which I asked, I mean if A1 = 1 and B1 = 3 then C1 = jan + feb + march, so A1 = the starting month and B1 = the number of months from A1.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
24 Sep 2012 à 08:54
=DATEDIF(DATE(2000,A1,1),DATE(2000,A1+B1,1),"d") -IF(B1-A1>0,1,0)

Similar discussions

how to learn macros
lakkakulak -
venkat1926 -

1 response
How to save a copy of an excel sheet using macros?
guido09 -
ac3mark -

3 responses
I am having problem with reactivating my facebook account
Ambreen -
Ambucias -

1 response