# Excel spreadsheet - how to calculate the 28th day

Hi, I am trying to make a workload tracker.

For context, I manually make a 3 monthly checklist where i calculate the next 3 due dates and type up it myself every month which is very time consuming.
i have a hundred over a 100 patients and they have a due date. so accross the month they are spread out into 4 weeks. so week 1 has about 15 patients due accross the week for example and week 2 has another 15 or 16 patients due etc. and then after the 4th week, we start from week 1 patients again.

I want to put it into a excel spreadsheet so the dates are calculated for me.

For example, lets say the first due date for TOM is 13/02/2024. so now i need the due dates for next 2 months fo TOM as well, which is the next 28th day. so the next 2 due dates would be 12/03/2024 and 09/04/2024.
so the next due date is after 28 days.

so lets say in the spreadsheet, the date in column B2 is 12/03/2024,
i want the spreadsheet to calculate the next 28th day and set the date in E2 to 12/03/2024 and the date in H2 to 09/04/2024.

what formulas will i use to get excel to calculate the due dates for me?

would appreciate any help urgently. thank you
Original post by Chez 01
Hi, I am trying to make a workload tracker.

For context, I manually make a 3 monthly checklist where i calculate the next 3 due dates and type up it myself every month which is very time consuming.
i have a hundred over a 100 patients and they have a due date. so accross the month they are spread out into 4 weeks. so week 1 has about 15 patients due accross the week for example and week 2 has another 15 or 16 patients due etc. and then after the 4th week, we start from week 1 patients again.

I want to put it into a excel spreadsheet so the dates are calculated for me.

For example, lets say the first due date for TOM is 13/02/2024. so now i need the due dates for next 2 months fo TOM as well, which is the next 28th day. so the next 2 due dates would be 12/03/2024 and 09/04/2024.
so the next due date is after 28 days.

so lets say in the spreadsheet, the date in column B2 is 12/03/2024,
i want the spreadsheet to calculate the next 28th day and set the date in E2 to 12/03/2024 and the date in H2 to 09/04/2024.

what formulas will i use to get excel to calculate the due dates for me?

would appreciate any help urgently. thank you

Have you seen this?

I don't have excel in front of me but try:

If your date is in cell E2, and you want the next date in H2 to be 28 days afterwards, then in cell H2 enter:

=DATE(YEAR(E2),MONTH(E2),DAY(E2)+28)
(edited 1 month ago)
Original post by LeTroll
Have you seen this?

I don't have excel in front of me but try:

If your date is in cell E2, and you want the next date in H2 to be 28 days afterwards, then in cell H2 enter:

=DATE(YEAR(E2),MONTH(E2),DAY(E2)+28)

i tried something and it seemed to have worked, i tried this:
=B2+28
and that did the trick. it added 28 days, so its worked.
I did a bit of playing around with it and managed to figure out enough things to be able to do what i need it to do.
thankfully, it make my life so much easier and will be less time consuming.