# Show days until payday

1. ## Show days until payday

Hi,
I'm trying to write a formula that will show how many days until payday, where payday is the 25th of every month.
Can someone point me in the right direction? I've found many that allow you to calculate days until a specific date, but I'm not sure how to write 'the 25th of THIS month' into a formula.

Thanks!

2. ## Re: Show days until payday

Maybe -

=DATE(YEAR(TODAY()),MONTH(TODAY()),25)-TODAY()

3. ## Re: Show days until payday

That worked - thanks very much!

4. ## Re: Show days until payday

Until Today is the 26th of a month, then it will be -1 (27th -2, 28th -3 etc)
You would probably want it to reflect the 25th of the NEXT month once we've passed the 25th.

Try
=DATE(YEAR(TODAY()),MONTH(TODAY())+(DAY(TODAY())>25),25)-TODAY()

5. ## Re: Show days until payday

Originally Posted by Jonmo1
Until Today is the 26th of a month, then it will be -1 (27th -2, 28th -3 etc)
You are absolutely right..

I missed that one completely..

6. ## Re: Show days until payday

Thanks - that's the one!

7. ## Re: Show days until payday

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1