Number of days to go and past days in a month (1 Viewer)

[TBC]

Hi.

I'm trying to find a formula that I can use to calculate the number of days left in the month and also the number of days current to past days in the month.
I've seen some examples of this when searching on line but I don’t know how I would add them to my current formula that I have to change each day.


Project Amount: [Fees_Collected]+(([Fees_Collected]/4)*26)
Project Amount_NB: [REFERRED]+(([REFERRED]/4)*26)

Thank you for your time and help

TCB

 

[fvdb]

hope this helps, yes its VBA but just want to show you the DateSerial tool i use in my queries where i have to update a date depending on the conditions

 datum = DLookup("datum", "tabel1")
Debug.Print datum
 endofmonth = DateSerial(Year(datum), Month(datum) + 1, 0)
Debug.Print endofmonth
startofmonth = DateSerial(Year(datum), Month(datum) + 0, 1)
Debug.Print startofmonth
 days_togo = datum - startofmonth + 1
Debug.Print days_togo

 

[TBC]

Thanks fvdb, but this dosent help me. How would I put this into a formula?

 

[fvdb]

Explain more wath your formula have to do. Also to calculate how much day left you need some date wich i not see in formula.

 

[TBC]

These two formulas work, I just want to automate them so the dates change when each day changes

Project Amount: [Fees_Collected]+(([Fees_Collected]/8)*22)
Project Amount_NB: [REFERRED]+(([REFERRED]/8)*22)

 

[El Jagang]

What fvdb is saying is that nowhere in the formulas you've shown is there an indication of where the date should be. Which parts of your formulas represent the date?