Calculate quarter semiannual and annual dates

[YasserKhalil]

Hello everyone
I have an attachment of expected output
I have fixed date in B13
I need to calculate the quarterly , semi-annual and annual dates for this fixed date

[Aardigspook]

Hi,

Use the DATE function:
Quarter:

Please Login or Register  to view this content.

Semi-annual:

Please Login or Register  to view this content.

Annual:

Please Login or Register  to view this content.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

[mahju]

Some amendment

Quarterly

B14:

Please Login or Register  to view this content.

By Annually

D14:

Please Login or Register  to view this content.

Yearly

F14:

Please Login or Register  to view this content.

Copied down

[newdoverman]

If EDATE is available to you, these will work ok.
Quarterly:

Please Login or Register  to view this content.

Semi Annually:

Please Login or Register  to view this content.

Annually:

Please Login or Register  to view this content.