Need Excel formulas!

Question

Need a formula where C2 has a date of 7/12/08 and I need C3 to generate the date 7/12/09; Also once I enter the Date in C2 I need the #1 to populate the cell named "July" I cant figout the wording and I know it's got to be pretty easy. I just want =IF(c2 ISnonblank =1) etc..I don't know! Help please!

Answer 1

In cell C2 put the date 07/12/08

In cell C3 put in the fx tool bar

=Sum C2+ 365

As for your date showing the month.

right click on the cell you want to change and format the cell, under number choose what style you want to be represented when you type in a number

Answer 2

The formula in C3 to show 1 year from the value in C2 is:

=DATE(YEAR(C2)+1,MONTH(C2),DAY(C2))

(Solves the problem of leap year)

Answer 3

in C3 you can do =C2+365 but on leap years it will mess up (try 2/28/2008

For the month you can go to C1 and type =c2, right click on the format and chose custom and type "mmmm"

Answer 4

if I understand this correctly

in C2 you'll have a date of 7/12/08

in C3 you want it to show 1 year from that date (7/12/09)

and in some other cell, you want to display a "1" if something has been entered in C2

in C3 enter

=C2+365  (format the cell to a date format)

in some other cell (the one you're calling "july"), enter

=IF(ISBLANK(C2)=FALSE, 1, "")

so if C2 is not blank, display a 1, otherwise display nothing ("")

------MORE------->

ok, so if you have columns jan, feb, mar...dec.  And based on the date entered in C2, you want a 1 to show up under whatever month matches the date, you'll need to enter this formula in each cell (under each month)

for January

=IF(ISBLANK(C2)=FALSE, IF(MONTH(C2)=1, 1, ""), "")

for each other month, change the MONTH(C2)=2 (for Feb, 3 for March, etc).

this formula firsts checks to see if C2 is blank.  If it's not, then it gets the month value from C2 and if it matches the month you want (1 for Jan, 2 for Feb, etc), it places a 1 as the result. Otherwise, it's places a blank ("") in the cell.