help in excel !!

4 posts · originally from https://geek.digit.in/community/threads/help-in-excel.72199/

hay guyz!

i need some help in MS Excel. suppose i enter a DATE in one column, how can i get a DATE of +30 days in other column.

what guys............??????

i think my question is not clear.ok let me explain it with help o an example.

suppose i m creating a customer billing system and if i enter a bill date, i must get a due date that will be 30 days after the Billing date....

its really urgent guys pls help.

Think tats simple man...

Suppose:
a1=10/1/2007(month/day/year)

b1=a1+30

u will get 10/31/2007

Tats it

thanks for the reply but i found out a way myself.....thanks a lot