formula to calculate every 3 months

krisniels

New Member
Joined
Aug 2, 2007
Messages
2
Hello,

I need help in creating a formula that would calculate every 3 months

this is to let other students know how long they have to complete an incomplete class before it turns to an F grade.

i.e if they get the incomplete in Fall 02 they basically have 5 semesters before it turns to an F grade

Fall 2002 Spring 2003 Fall 2003 Spring 2004 Fall 2004 Spring 2005

Can this be done with an IF statement ? of should i just type it our?
any info would help
thanks
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
I don't think you've made your requirement very clear. What information do you have and what do you want a formula or formulas to calculate?

If you have a date in A1 you can add 3 months to it with

=DATE(YEAR(A1),MONTH(A1)+3<DAY(A1))

or

=EDATE(A1,3)

note: EDATE is part of Analysis ToolPak add-in
 

Forum statistics

Threads
1,181,102
Messages
5,928,063
Members
436,586
Latest member
latintxn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top