how calculate remaining days based on same days for each month

[Ali M]

Hello
I want showin result in B2 gives me how remains days based on day 28/mm/yyyy . the day (28) is the same thing for each month .
for instance if date(today) is 14/09/2022 when calculate for date 28/09/2022 then the result in B2 should be 14 days remaining
thanks

 

[Kerryx]

It probably should read "0 DAYS REMAINING "

 

[Ali M]

If Today was the 29th why would you get 14 days?

just give you example basd on OP
another examples
date today(13/09/2022) & finishing ( 28/09/2022 ) then result will be 15 days remaining and if date today(13/09/2022) & finishing ( 29/09/2022 then result will be 15 days remaining
date today(12/09/2022) & finishing ( 28/09/2022 ) then result will be 16 days remaining and if date today(13/09/2022) & finishing (30/09/2022 then result will be 16 days remaining as you see if the days(29,30,31) should keep the result up to 28/09/2022 even the finishing day for 29 ,30,31 . in the most important the ending of day should be up to 28. all of cases show the result even if past 28 .

 

[Fluff]

But if you the number of days from today until the 28th, what happens when today if AFTER the 28th? ie date today(30/09/2022) date finishing (28/09/2022)

 

[Ali M]

sorry F luff ! I no know why ask all of theses questions , but you answered me . based on your formula is logical . yes should be empty
just calculate from 1 -28 for each month .
many thanks for your time and help

 

[Fluff]

Glad we could help & thanks for the feedback.