Automatic calculate days until salary

[Ametz]

Lets say i want a cell to show X-days until salary (that i get on the 27't each month)

I'm thinking something like this (translated):
=DATE(;;27)-TODAY()

Please Login or Register  to view this content.

So i don't need to change the date every month (Because that i get to work with "=TODAY()-L3" where L3 is the salary date that i update manually every month).
But the formula i try to make that is going to be automatic doesn't work (yet).
So what am i missing in "=DATE(;;27)-TODAY()"?

[Pete_UK]

You need to specify the year and the month within the DATE function. In English it would be:

=DATE(YEAR(TODAY()),MONTH(TODAY())+IF(DAY(TODAY())>27,1,0),27)-TODAY()

You will need to change the commas ( , ) to semicolons ( ; ), as well as translate the function names to Swedish.

Note that you need the IF statement in there to cater for TODAY being after the 27th of a month.

Hope this helps.

Pete

[Roel Jongman]

I think this formula will always work, never need to manually change any date not for next month and also not for next years
the EDATE formula jumps to next month if the day is >27 and use this months 27th date to calculate until next payday on 27th..

Please Login or Register  to view this content.

or swedish version

Please Login or Register  to view this content.

[Ametz]

Ok, i think i got it to work now

Please Login or Register  to view this content.

Thanks

I just needed to copy format from another empty cell and "bam" it worked

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.