Formula in excel for a date
Solved/Closed
Gerberreinette
TrowaD
- Posts
- 13
- Registration date
- Friday March 4, 2016
- Status
- Member
- Last seen
- July 6, 2021
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- 1st, 2nd, 3rd position formula in excel
- How to calculate positions(1st,2nd,3rd...) in Excel ✓ - Forum - Office Software
- Formulas for 1st and 2nd position in class - Forum - Office Software
- Calculation of positions in excel ✓ - Forum - Excel
- Student position formula - Forum - Excel
- How to calculate position (1st,2nd,3rd) in excel....? - Forum - Excel
3 replies
TrowaD
Jul 6, 2021 at 11:44 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jul 6, 2021 at 11:44 AM
Hi Gerberreinette,
Here are the requested formula's per cell:
E2: Enter you start date here: 2010/03/01
F2: =DATE(YEAR(E2),MONTH(E2)+6,DAY(E2)-1)
E3: =F2+1
F3: =DATE(YEAR(E3),MONTH(E3)+6,DAY(E3)-1)
E4: =E2
F4: =DATE(YEAR(E4),MONTH(E4)+18,DAY(E4)-1)
E5: =E2
F5: =DATE(YEAR(E5),MONTH(E5)+24,DAY(E5)-1)
E6: =DATE(YEAR(E2)+1,MONTH(E2),DAY(E2))
F6: =DATE(YEAR(E6),MONTH(E6)+6,DAY(E6)-1)
E7: =F6+1
F7: =DATE(YEAR(E7),MONTH(E7)+6,DAY(E7)-1)
E8: =E6
F8: =DATE(YEAR(E8),MONTH(E8)+18,DAY(E8)-1)
E9: =E6
F9: =DATE(YEAR(E9),MONTH(E9)+24,DAY(E9)-1)
Best regards,
Trowa
Here are the requested formula's per cell:
E2: Enter you start date here: 2010/03/01
F2: =DATE(YEAR(E2),MONTH(E2)+6,DAY(E2)-1)
E3: =F2+1
F3: =DATE(YEAR(E3),MONTH(E3)+6,DAY(E3)-1)
E4: =E2
F4: =DATE(YEAR(E4),MONTH(E4)+18,DAY(E4)-1)
E5: =E2
F5: =DATE(YEAR(E5),MONTH(E5)+24,DAY(E5)-1)
E6: =DATE(YEAR(E2)+1,MONTH(E2),DAY(E2))
F6: =DATE(YEAR(E6),MONTH(E6)+6,DAY(E6)-1)
E7: =F6+1
F7: =DATE(YEAR(E7),MONTH(E7)+6,DAY(E7)-1)
E8: =E6
F8: =DATE(YEAR(E8),MONTH(E8)+18,DAY(E8)-1)
E9: =E6
F9: =DATE(YEAR(E9),MONTH(E9)+24,DAY(E9)-1)
Best regards,
Trowa
Gerberreinette
Jul 6, 2021 at 12:22 PM
- Posts
- 13
- Registration date
- Friday March 4, 2016
- Status
- Member
- Last seen
- July 6, 2021
Jul 6, 2021 at 12:22 PM
Hi Trowa
Thank you so much this is amazing.
One question.
Is there maybe a way to enter a formula that I can just drag down to the rest of the years? I need to do it for FYS 2010 to 2025.
Thank you for the help I appreciate this so much.
Thank you so much this is amazing.
One question.
Is there maybe a way to enter a formula that I can just drag down to the rest of the years? I need to do it for FYS 2010 to 2025.
Thank you for the help I appreciate this so much.
TrowaD
Jul 13, 2021 at 11:57 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jul 13, 2021 at 11:57 AM
Hi Gerberreinette,
You can; select cells E6 to F9 and drag that selection down as far as needed.
Best regards,
Trowa
You can; select cells E6 to F9 and drag that selection down as far as needed.
Best regards,
Trowa